Good morning. I am hoping that someone out there can help me. I would like to Combine Payments on multiple sheets with same invoice #, I have multiple rows for each invoice #. I have been sending both worksheets to a pivot and then doing a lookup off of one to the other to combine the payments. I'm thinking that I could create a macro to copy the columns that I want onto the same sheet so that it can be run by people that are not techy
I'd like to copy the following columns from the LI Payment sheet to the IT payment sheet at the end
1. Column A to Column B
2. Column E to Column P
3. Column G to Column H
4. Column AO to Column D
5. Column AS to Column AO
6. Column AV to Column AR
Any thoughts? A sample of the data is attached. Any help would be greatly appreciated.
Bookmarks