[Solved] Fill multiple sheet cells referencing sheet#
Posted: Thu Mar 25, 2021 9:55 pm
Hello
I am trying to make a macro that would automatically fill a sheets cell with data and assign a # value based on the number of the sheet.
Example
I have 20 sheets. I want every sheets A2 cell value to be filled with "=Sheet1.A#" where # would equal that sheets position in the list of sheets. So sheet #2 would get its A2 cell set as "=sheet1.A2".
I would like it to not apply for sheet 1. I also need it to fill the B2 value of every sheet with "=Sheet1.B#" in a similar fashion.
I am trying to make a macro that would automatically fill a sheets cell with data and assign a # value based on the number of the sheet.
Example
I have 20 sheets. I want every sheets A2 cell value to be filled with "=Sheet1.A#" where # would equal that sheets position in the list of sheets. So sheet #2 would get its A2 cell set as "=sheet1.A2".
I would like it to not apply for sheet 1. I also need it to fill the B2 value of every sheet with "=Sheet1.B#" in a similar fashion.