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. |
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. |
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. |
All times are GMT +1. The time now is 09:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com