Hi Everyone,
I am having a issue writing a macro. See attached Excel file..I am trying to rename a worksheet with a date (Cell D1) and the first 5 letters of a name (CellB2) and then have the F2:F28 column transfer into another worksheet (Campbells!) based on the date (Cell A3:E3) Any help with this would be fantastic!!!!
Thanking you in advance
Matthew
Bookmarks