SOLVED

filling suceeding cells

Copper Contributor

I have 12 excel sheets for the months of the year. When I put in a value in a cell on the Jan sheet I want it to automatically change the same cell on succeeding sheets. Is there a formula to do that?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@thutleycomcastnet Firstly, i wonder why you have 12 separate sheet, but trust you have a good reason for it. To answer your question, you could select the January sheet, press Shift and hold and press the December sheet. Enter the value in January and press Enter. This will enter the value in all of the grouped sheets. Click on any of the sheet tabs to ungroup the sheets. 

Thank you so much. It works great.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@thutleycomcastnet Firstly, i wonder why you have 12 separate sheet, but trust you have a good reason for it. To answer your question, you could select the January sheet, press Shift and hold and press the December sheet. Enter the value in January and press Enter. This will enter the value in all of the grouped sheets. Click on any of the sheet tabs to ungroup the sheets. 

View solution in original post