We are importing data into a new ERP system and I need to create an automated Excel sheet where we can convert the price lists into importable data. Example: I have a price list with several columns of data that have to copied to the correct columns in the import template. Check column header, and copy to same column header in import spreadsheet. That's the easy part. The hard part is each product line has 9-12 price lists in columns that have to be transferred to the import spread sheet, but they must be inserted in rows below the product. Row 3 is Widget so Price lists 1-12 have to be copied to a specific cell in row 4, 5, 6, 7, 8, 9, 10, 11, etc...leaving the complete line blank except for the price list reference and the price of the product. Line above determines the product, lines below fill in the each price list price. It has to repeat this for the whole spreadsheet. Anyone?
27 freelancers are bidding on average $23 for this job
Hello, Would you please share the Excel file and add details onto that file. It seems like an easy text manipulation project. Completed many projects like this one. Best Regards, Serdar Yalcin
Hi, I'm interested in the job. I have rich experiences in such kind of jobs and can complete it soon once getting hired. Feel free to contact me if necessary. Best Regards,
Respected Sir/Madam, I have good knowledge of Excel and having 5+ experience on the same. So I am suitable candidate for this job. I will come upto your expectation