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.
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