I have a wooksheet that I need to copy each row to various worksheets. If cell in column a = 111 then copy to sheet 2, cell in column a = 222 then copy to sheet 3, cell in column a = 333 copy to sheet4 or cell in column a = 444 then copy to sheet5. I have code that will do this but here is the kicker. If cell in column c is different from previous match then I need to copy that row to a new sheet. And if this makes no sense then here is what I have:
I have 4 different account numbers in column a and I can have up to 6 differnent invoice numbers in column c. I know the account numbers but the invoice numbers will be different every time. Thanks for your help.
I have 4 different account numbers in column a and I can have up to 6 differnent invoice numbers in column c. I know the account numbers but the invoice numbers will be different every time. Thanks for your help.