VBA to export two set of data from one file to two file

Dear expert

I have saved N number of files in path, i want export unique values into particular workbook in particular sheet.

i have saved backup file in one path with sheet of Sub_Account which contains multiple partner name. i want export data of Supreme Systems to Supreme.xlsb workbook[sheet!sub_account] and as well as export data of Webx Technologies to Webx.xlsb workbook[sheet!sub_account]

VBA code run from empty workbook.
Copy from BackUp.xslb sheet(Sub_account) Only Supreme Systems Data's Paste Into Supreme.xlsb workbook[sheet!sub_account]
Copy from BackUp.xslb sheet(Sub_account) Only Webx Technologies Data's Paste Into Webx.xlsb workbook[sheet!sub_account]



Thanks

One of the sheet is named Sub-Account, not Sub_Account, so you need to change it before run.

Please Login or Register  to view this content.

Hi sir It works fine!! I want to keep the backup file as closed workbook in one path and i want run code from empty workbook . but the code which run from backup file only.. Like Supreme.xlsb, Webx.xlsb in one path and backup file in one path. run vba from fresh workbook. code copy data from backup file to Supreme.xlsb, Webx.xlsb