Hi all, I'm working with a 14 page workbook, where the first sheet is my control sheet. Second tab is named Jan, 3rd tab is Feb, all the way to Dec. On the first sheet or "Control sheet" I have all my formulas and are perfectly duplicated in each month cell to cell #. Is there a way to drag the formulas so that the SHEET name, changes from Jan, to feb, to mar, etc..... Thanks for your time. I'm using a find and replace now but I've got a long way to go if there is no better way. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Is there a faster way?
- Thread starter roc_ent
- Start date
Similar threads
- Question
- Solved
