I have created a macro that splits into files based on a column on the spreadsheet. In this same macro I'm also copying an additional spreadsheet (another tab) from the same workbook into the new workbook that is created. Is there a way that I can populate some of the fields on this new worksheet based on values in the new spreadsheet - the contact name will always be the same on each file and is in column B. then I would like to sum up all the values in column S and add that to this new sheet that is added.
Here is my code.
Bookmarks