Edit: The Macro below is now working for the copy, I had misspelled the sheet name tab...duh !
however I'd still appreciate your help on the other bits please
I've tried various macro's I've found, but can't get them to do what I need, such as..
I need a macro to copy Values only from sheet1 B6:I6 to the first Empty row on sheet2 A to H
It would also be helpful that if after copying, on sheet1 Cells b6:c6 and b9:g30 and j6 the contents were cleared.
Additionally, rows on sheet2 a2 onwards to be sorted alphabetically on a2
any help would be appreciated
Many thanks
Bookmarks