Hello and thank you for your help once again
I have a macro that goes from the bottom up and takes the first 2 digits of a value in column A and creates a new sheet and paste the cuts and copys each value into its rightful sheet i.e.
AA12345678
AB12345678
CC12345678
DD12345678
"sheet"AA
AA12345678
"sheet" AB
AB123456789
"sheet" CC
CC12345678
"sheet" DD
DD123456789
Code as follows
This works perfectly
The issue I have is now I would like this macro to copy the contents of both column A and B as it only copies column A for now but it can be the entire row if that makes it any easier.
Thank you for you help
Bookmarks