We are selling our products in Amazon Germany, France, UK and Italy and we have one Excel file for each country. Each excel file has many columns and many rows. Each column has a name which is placed in row 3 always. And in all 4 excel files the columns are named same but the columns are ordered different and that is my problem.
I need to copy several rows from german excel file to italy excel file for example but when i paste them the columns are not in correct order because columns in italy, france and UK file are different ordered.
So i need a script or macro that will help me to copy and paste several rows from one excel file to the other and will make sure that the data is pasted into the correct columns. (Remember the columns always have the name in 3. row and in all 4 excel files the columns are named same way so by this you can paste the data into correct column).
I don't mind what kind of script, macro or function you create but for me is just important that i can choose the rows that should be copied and that i can choose the excel file into which it should be pasted. And then it should be pasted into the same named columns.
I will send you the 4 Excel files in private message.
13 freelancers are bidding on average $70 for this job
Hello there, I would like to be considered for this job as I have great working experience in excel VBA writing. It seems to be 2-3 days work. with testing Thanks, Ramesh
I am already work on this type of scripts so its very easy for me to make me this. Please assign this project to me. I will deliver to you as soon as possible.