I don't think I made my question clear enough. On the Original Spreadsheet
we have the the following column headers:
Date / Is / Location / 10621 / 10609V / 10607VSO / 10607VTO / 10609D /
10607DSO / etc.
and then below each headeris the data as follows:
03/01/09 / 0106 / Ticket Office Window 6 / $444.00 / $2257.00 / $0.00 /
$0.00 / $0.00 / $0.00 / etc
03/01/09 / 0105 / Ticket Office Window 2 / $1285.00 / $3078.00 / $325.00 /
$0.00 / $0.00 / $0.00 / etc.
I want to be able to pull the Dollar amounts to my other worksheet and have
them flow down by using a formula. When I try either of the formulas listed
here they do not work. Is this possible?
--
TC
"Max" wrote:
In the top cell C1, instead of:
Cell C1 = "=Sheet1!C2"
you could put this in C1, then just copy down all the way:
=OFFSET(Sheet1!$C$2,,ROWS($1:1)-1)
The above will return the desired pattern, viz.:
in Cell C2 = "=Sheet1!D2"
in Cell C3 = "=Sheet1!E2"
etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"TLC" wrote:
We are creating a huge spreadsheet 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 spreadsheet 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 spreadsheet 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
--
TC
"TLC" wrote:
We are creating a huge spreadsheet 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 spreadsheet 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 spreadsheet 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