•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to pull a specific cell from previous sheet to the next sheet
I have a file contains 52 sheets. Each sheet names by sequential name like Jan Wk1, Jan Wk2, Jan Wk3, Jan Wk4, Jan Wk 5, Feb Wk1, Feb Wk2……
I have to create a new sheet by copying&pasting the template from previous week. Cell H36 is the total and the number is vary each week. How to move cell H36 from previous sheet? There are a lot of tutorial for transferring data from master sheet. Nothing for “previous sheet”
[link] [comments]
Want to read more?
Check out the full article on the original site