Hello, I'm trying to see if there is anyway to create a macro/VBA code to copy/paste data into a worksheet repeatedly. I have attached the file. On the Data tab each row represents a new sheet header I need to create. I do this by taking each row and copying it into the space in the "Header Populate" tab. This populates the appropriate data into the "Sheet Header" Tab. I would then create a copy of the Sheet Header tab and copy/paste values on it so I have running workbook of Sheet Headers to print. I would need to do this until the end of Data so it would create 17 tabs. Is there a way to write a Macro code to automate this? I would need it to create as many sheets as there are rows of data in the data tab so that I can do this in bulk. Any help would be appreciated. Thanks
Bookmarks