| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i copy formula and change worksheet instead of cell
sheet 1 cell 4a =+'M21'!B1, cell 4b =+'M21'!B27, etc..
Sheet 1 is a report, sheet 2 (M21), 3, 4, etc contain data that needs to feed the report, how do i copy the formula to the next line and change the reference to which sheet it pulls from instead of it changing the cell on the sheet it pulls the data from? Can some one PLEASE HELP!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| How do I create formula to change cell color | Excel Worksheet Functions | |||
| HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
