| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a formula down a summary sheet
I have a workbook with multiple spreadsheets from E73 to I91. On each sheet I
have a total that I would like to copy to a summary sheet. I have pasted the first formula into the summary sheet which is ='E64'!$K23$. I now want to copy this formula down with the sheet reference incrementing by one e.g the next one needs to be ='E65'!$K23$ and the next ='E66'!$K23$ and so on. What is the best and easiest way to do this??? Many thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to get sum from one 31 sheets to a summary sheet. | Excel Discussion (Misc queries) | |||
| Formula for a Summary Sheet | Excel Discussion (Misc queries) | |||
| Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) | |||
| formula for copying from one sheet to another | Excel Worksheet Functions | |||
| Copying a formula with different sheet refs | Excel Discussion (Misc queries) | |||
Threaded Mode
