Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the formula that works for this
I have a B/S on one page and the data resides on another page for all 12
months. By changing the month number on the Balance Sheet (B/S) it pulls the data for that period to the apporpriate accounts. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the formula that works for this
Assuming that the format is exactly the same on each sheet then the offset
function will do the job Place the following on sheet1 B7 =OFFSET(Sheet2!A7,0,B$6) B6 contains the month you want to call from 1 to 12. Copy as required. Regards Peter A "dolson" wrote: I have a B/S on one page and the data resides on another page for all 12 months. By changing the month number on the Balance Sheet (B/S) it pulls the data for that period to the apporpriate accounts. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the formula that works for this
The format is not the same on each page
"Billy Liddel" wrote: Assuming that the format is exactly the same on each sheet then the offset function will do the job Place the following on sheet1 B7 =OFFSET(Sheet2!A7,0,B$6) B6 contains the month you want to call from 1 to 12. Copy as required. Regards Peter A "dolson" wrote: I have a B/S on one page and the data resides on another page for all 12 months. By changing the month number on the Balance Sheet (B/S) it pulls the data for that period to the apporpriate accounts. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the formula that works for this
I guess you need to provide more information, but the offset will work
providing it is pointed in the right direction. For instances, can we assue that the second sheet with each month's figures are set as: Jan Feb Mar Sales 2000 2200 2300 Costs 500 540 600 Gross Profit 1500 1660 1700 Peter A "dolson" wrote: The format is not the same on each page "Billy Liddel" wrote: Assuming that the format is exactly the same on each sheet then the offset function will do the job Place the following on sheet1 B7 =OFFSET(Sheet2!A7,0,B$6) B6 contains the month you want to call from 1 to 12. Copy as required. Regards Peter A "dolson" wrote: I have a B/S on one page and the data resides on another page for all 12 months. By changing the month number on the Balance Sheet (B/S) it pulls the data for that period to the apporpriate accounts. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula works but formula shows in cell??? | Excel Worksheet Functions | |||
Formula Partially Works, Please Help | Excel Worksheet Functions | |||
IF formula works one way and not the other | Excel Worksheet Functions | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
Formula Works Only Sometimes??? | Excel Worksheet Functions |