Macro for arrange worksheet

john5599

Board Regular
Joined
Mar 11, 2010
Messages
221
I have an excel file as the sample file share link . I would like to have a macro for arranging the shee1 to sheet2. Then I want to compare the sheet2 with another workbook named book1 sheet named Data1 for Invoice No, Item Name, and party name. If work book Data1 don't have such records then append these records under the same column names in Data1 worksheet. I am expecting :rolleyes::rolleyes::rolleyes::rolleyes: I have record a macro there with sample file


https://www.dropbox.com/s/5ykvgwcyi6vsogx/sale.xlsm?dl=0
 

Forum statistics

Threads
1,084,962
Messages
5,380,841
Members
401,699
Latest member
ijazkhan01

Some videos you may like

This Week's Hot Topics

Top