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!! |
No need for the plus sign btw
=INDIRECT("'M"&ROW(21:21)&"'!B27") copied down will get B27 from M21, M22 and so on Regards, Peo Sjoblom "dal0506" wrote: 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!! |
That worked until I came to a sheet that was not consecutively numbered. How
do I combat that, data sheets (worksheets) will be added and removed and won't always be consecutive??? "Peo Sjoblom" wrote: No need for the plus sign btw =INDIRECT("'M"&ROW(21:21)&"'!B27") copied down will get B27 from M21, M22 and so on Regards, Peo Sjoblom "dal0506" wrote: 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!! |
All times are GMT +1. The time now is 10:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com