Hi,
1 . I receive individual multiple excel files from one customer and I need to combined them into ONE BIG file and perform something like conditional formatting 'duplicate values' such as the invoice number, the date, the $amount and remove the duplicate from the file. Please show the steps in PAD so I can see what you did.
2. I also receive one excel file form another customer. This time the excel file contain 4 tabs. The first tab is garbage and I need to delete it completely. The second tab contain good data. But it contain Row 'A' is the invoice number, 'B' is the date, 'C' is the currency, and 'D' is the $amount. I only need Row A, B, and D. I need to delete Row C. The third and the fourth tabs are the same style with the second tab. After I delete Row C on all three tabs, then I need to put them back into ONE BIG file and then perform something like conditional formatting 'Duplicate Values' on all the ROWS and delete the duplicate and finally save the file with a new name. Please show the steps in PAD so I can see what you did.
Thank you!
