I need to generate 3 excel files. Summary is listed as following.
1. Generate an excel file with data of 4 fields from two excel files with data of 2 fields. The process involves 1x duplicate data, 1x change data name to [url removed, login to view], 1x calculate avg price and 1x generate time stamp for each data in increment of minutes or hours.
2. Generate an excel file with data of 2 fileds from an excel file with data of 2 fields and a folder of html files. The process involves 1x find and insert data's corresponding name and description by comparing two excel files. The description for each data is contained in each html file.
3. Generate an excel file with data of 3 fields from an excel file of 2 fields, an excel file of 3 fields and a folder of html files. The process involves 1x compare data to find corresponding html file, 1x extract 2 sets of data from tables in the html file and insert to the new excel file. Before insertion, one set of data has to be converted to different names by comparing to the 3 fileds excel file.
35 freelancers are bidding on average $52 for this job
Hi, I have more 10 years experience in MS Office automation, include VBA and VB.NET, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex
Hi, I can do this work for you. I have expertise in this field that you require and i assure you the best work . My bid is as [url removed, login to view] give me this project. Hope to start good business relation with you. Adeel