I've got a column of data (Months) that I need to insert into a cell in multiple worksheets.
I know if it was within one worksheet I'd just drag the formula down to get it to change. Is there a way to do that in a range of tabs? It needs to be done way to many times and I'd rather not manually enter it.
Ex: ='Adjusted Unit Lifespan'!D12 then ='Adjusted Unit Lifespan'!D13, ='Adjusted Unit Lifespan'!D14 all into cell N2.
I've actually got a couple of these I need to do but I figure if I can get some direction on one I can use the same method for the other spots.
Thank you so much for your help! :)
Just in case this is needed, the worksheet names have either "Cedar Park" "Cedar River" or "Golden Pines" as part of the worksheet name.