Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a formula to carry totals from 1 sheet to another
I use the formula ='[RENT-EXCEL 2009.xlsx]APR09'!N2 to carry amounts from one
workbook sheet to another. My problem is I have 83 amounts to carry over and I have to do each one seperately by changing the "N" line number each time and then I have to verify my worksheet name for each entry. Is there an easier way. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a formula to carry totals from 1 sheet to another
Copying that formula down will change the reference to N3,4,.... If you are
not looking for a continuous reference, please let us know whats the next row to be referred after 2.... If this post helps click Yes --------------- Jacob Skaria "KGB003" wrote: I use the formula ='[RENT-EXCEL 2009.xlsx]APR09'!N2 to carry amounts from one workbook sheet to another. My problem is I have 83 amounts to carry over and I have to do each one seperately by changing the "N" line number each time and then I have to verify my worksheet name for each entry. Is there an easier way. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a formula to carry totals from 1 sheet to another
2 questions:
After N2, which direction are you looking to copy *from*, across (O2), OR down (N3)? On the second sheet, which direction are you looking to paste *to*; down or across? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "KGB003" wrote in message ... I use the formula ='[RENT-EXCEL 2009.xlsx]APR09'!N2 to carry amounts from one workbook sheet to another. My problem is I have 83 amounts to carry over and I have to do each one seperately by changing the "N" line number each time and then I have to verify my worksheet name for each entry. Is there an easier way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for totals throughout sheet | Excel Discussion (Misc queries) | |||
Carry data from sheet to sheet automatically | Excel Discussion (Misc queries) | |||
HOW TO CARRY A VAIABLE RESULTS FROM EXCEL SHEET PROCEDURE TO A MODULE | Excel Discussion (Misc queries) | |||
carry over data to other sheet - help needed | Excel Discussion (Misc queries) | |||
Is there a way to carry formatting to a different sheet? | Excel Discussion (Misc queries) |