I have excel files in folders. Every sheet has a row of codes and then totals above it.
These sheets are by the week. I want to open each sheet, read the row with the codes, then copy and paste the cell directly above it depending on the date in the title (or a specific cell, whichever is easier)
Any help is greatly appreciated.