Re: Copy Data from One Spreadsheet to Another ??????

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You can put these formulae in Sheet2 in the cells stated:

A2: =INDEX(Sheet1!A:A,INT((ROW(A1)-1)/5)+2)

B2: =INDEX(Sheet1!B:B,INT((ROW(A1)-1)/5)+2)

C2: =INDEX(Sheet1!C:G,INT((ROW(A1)-1)/5)+2,MOD(ROW(A1)-1,5)+1)

Then just copy these down as far as you need to.

Hope this helps.

Pete

On Aug 18, 10:32 pm, TLC <T...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
We are creating a huge spread*** to integrate data into our Accounting
System and need to know if there is an easy way to make changes to formulas
to pull data accross columns instead of rows.

For example we have data in the original spread*** as follows:

Column A = Date
Column B = Location
Column C = Cash
Column D = Visa
Column E = MC
Column F = Amex
Column G = Discover

In the new spread*** we want the data to be as follows:
Row 1 = Date, Location, Cash
Row 2 = Date, Location, Visa
Row 3 = Date, Location, MC,
Row 4 = Date, Location, AMex
Row 5 = Date, Location, Discover

SO our formula to pull the information is as follows"
Cell A1 = "=Sheet1!A2"
Cell B1 = "=Sheet1!B2"
Cell C1 = "=Sheet1!C2"

Cell A2 = "=Sheet1!A2"
Cell B2 = "=Sheet1!B2"
Cell C2 = "=Sheet1!D2"

Is there a way to make the column change for  the formula in Column C?
--
TC

.

Quantcast