I have an Excel workbook that will eventually have about 28 sheets. I was able to find code that let me copy the first time card properly and change its tab name. However, I am having issues that when the new sheet is created the date in the new sheet still corresponds to the date in the source. I was wanting to use the corresponding date in the summary page to populate the date in the new sheet. I have looked at VLookup functions and I see them used in reverse. I was also wanting to know if it might be possible to use the sheet names to create the corresponding date.forum.ozgrid.com/index.php?attachment/71104/
I have attached the beginning of the workbook along with the current sheets that I am trying to properly do. Right now I have to go into each sheet and modify C4 to the corresponding pay period in the summary page.