I am looking for a macro code to loop a unique code. I need cell C4 of my first sheet to be changed to the value based on a column on another sheet. I need it to grab the next cell of this same column, insert it in C4, and hit enter. Following that, I need the entire workbook, including hidden sheets, to copy to a new workbook and be named what C4 changed to.
I need this to loop this procedure until I hit an empty cell in that column.
I ultimately need this to generate 70 different workbooks with the name of value in C4. In case you are wondering, C4 is a cell that changes a ton of sumifs to generate a unique report for each specific client. I also need all the cells to keep their formating and formulas as I have a dropdown list linked to access data.
I have scoured the internet for a code like this and have not found anything quite like this. Thanks in advance!
I need this to loop this procedure until I hit an empty cell in that column.
I ultimately need this to generate 70 different workbooks with the name of value in C4. In case you are wondering, C4 is a cell that changes a ton of sumifs to generate a unique report for each specific client. I also need all the cells to keep their formating and formulas as I have a dropdown list linked to access data.
I have scoured the internet for a code like this and have not found anything quite like this. Thanks in advance!
Last edited: