I have 2 in 1 files for the same project.
File_1_All_Suppliers: (developed in freelancer) In this attached excel file I have to put products data from different suppliers (Sheet 1). On that time I thought 5 suppliers will be enough, but no: I NEED TO EXPAND TO 10 SUPPLIERS and maintain the procedure: DUPLICATE VALUES (will highlight all the duplicate values in sheet 1); EXTRACT DUPLICATES will transfer duplicated data to sheet 2; EXTRACT UNIQUE, will copy no duplicate data to sheet3.
ONLY NEED TO EXPAND THE FIELDS FROM 5 PRE DEFINED COMPANIES TO 10
File_2_Combine_Duplicates: (developed in freelancer) I will copy all the duplicated data from the sheet2 that I grab in File_1_All_Suppliers.
So in this file, I ALSO NEED TO EXPAND TO 10 SUPPLIERS like previous file. We should maintain the procedure: EXTRACT DATA will grab all the duplicated data and align it in sheet2 (extracted data) puting the best price in each company.
I would like, if not so heavy, to aggregate these 2 files:
In file 1 the macro will detect, extract unique values and the duplicates can go to shet2 (like right now) or go straight to the file 2. From here, the procedure will be the same.
18 фрилансеров(-а) готовы выполнить эту работу в среднем за $33
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.
Hello :) How are you? Thanks for your posting. I have experience in writing macros VBA for Excel. Can we discuss about your project in details? Best regards
Hi, I will follow your provided instructions and then put then into an excel file. I can work full-time to finish them ASAP. I will show you few samples initially. Let's discuss and start.