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. |
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) |