Good Day,
I've got a report that goes out with five sheets within the workbook. To start we export a pre-packaged report from our system (Sheet 1). We then create 5 additional sheets each with their own unique name. We then look at the cell value in Column F and if it matches one of the sheet names then we cut&paste that entire row into the next available row within that sheet. Once all of the rows from Sheet 1 have been distributed to one of the other five sheets we delete Sheet 1 so you're just left with the five sheets.
is that clear? I hope so!
I need a piece of VBA to add into the rest of my Macro to do this if I can.
thanks for your help
Bookmarks