| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COPY DOWN INCREASING WORKSHEET REFERENCE BY 1
I've got =SUM(BDM001!M;M) in C6, ie referring to column M in worksheet
BDM001. In C7, I want =SUM(BDM002!M:M0, ie referring to worksheet BDM002, in C8 I want =SUM(BDM003!M:M), etc. How do I copy down? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy same formula with with different worksheet reference | Excel Discussion (Misc queries) | |||
| copy worksheet without reference to old .xls file | Excel Discussion (Misc queries) | |||
| Formula for Increasing a Cell Reference by a Given Number | Excel Worksheet Functions | |||
| Using a cell reference to copy rows to a new worksheet | Excel Discussion (Misc queries) | |||
| How do I copy a formula with increasing worksheet numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
