I need to take every row (2 through...) from a downloaded spreadsheet and place them in their own spreadsheets. The next day a new spreadsheet will be downloaded and it's rows will need to be added to the previous spreadsheets that were created the first time. This process needs to be done every day.
Can we create a macro or write VBA code to do it? I'm stuck on how to do loops when creating new workbooks or worksheets... every time i run the program.
Here is an example of the downloaded spreadsheet... and a second example representing the following day's downloaded spreadsheet.