Em Andamento

Excel script or macro needed to copy data from one excel file to other

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.

thanks

Habilidades: Programação C, Excel, VB.NET, Visual Basic

Ver mais: modify excel file data, excel file data mining, scrub excel file data, excel change data connection script, excel file data mysql table java, excel file data entry, display excel file data javascript, read modify excel file using php script, import excel file data grid aspnet, excel file read php script

Acerca do Empregador:
( 58 comentários ) Hamburg, Germany

ID do Projeto: #8043001

Premiar a:

Ayan

Hello, I can write an excel macro to resolve this issue. I can do it within few hours. Ready to start now. Please let me know when we can discuss further.

$30 USD em 0 dias
(48 Avaliações)
4.8
jawadaman

Hi I am interested in this project. I am an experienced MS Excel worksheet programmer using VBA. I can do this job for you. If interested in hiring me then please let me know so that we can discuss it further. T Mais

$72 USD em 3 dias
(22 Avaliações)
4.4

13 freelancers estão ofertando em média $70 para este trabalho

avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Mais

$83 USD in 0 dias
(106 Comentários)
6.2
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 240 projects. Please look at the feedback left by my employers to know more about my work. Wai Mais

$100 USD in 4 dias
(75 Comentários)
5.9
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Mais

$75 USD in 3 dias
(54 Comentários)
5.5
kevivu

Having more than 11 years of experience in banking /finance /accounting, business analysis, Data analysis and Statistical analysis. Expert in MS EXCEL which includes Formulae, Macros, pivot , shortcuts, templates, Mais

$72 USD in 2 dias
(27 Comentários)
4.7
Yorkiebar15

Hello, I do not have experience in creating macros, however since you mentioned that you do not mind what kind of method is used to get this job done I am contacting you for a slightly alternative version of the pro Mais

$80 USD em 1 dia
(17 Comentários)
3.9
cobol1962

A proposal has not yet been provided

$133 USD in 5 dias
(2 Comentários)
2.7
rameshmahala

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

$72 USD in 4 dias
(2 Comentários)
2.4
nwss1986

Hi, I am a certified programmer with 6 + years of experience in ms office application programming and add ins.i am well versed in vba and also can program excel files through c#.net.i can complete your project in a day Mais

$40 USD em 1 dia
(3 Comentários)
1.9
abhilash1122

Hi... To fulfillfill this requirement we can record a macro using the built in excel vba tool and we can minimize the effort in writing code manually to some extent. I have 2.5 years in working with vba reports and i Mais

$47 USD em 1 dia
(1 Comentário)
0.8
DanielFRodriguez

Hi ! My Name is Daniel Rodriguez and I am very excited to have the opportunity to work for you, and have the intention to bring you and your business nothing but the best. I can offer you the best of my knowledge and Mais

$30 USD in 0 dias
(0 Comentários)
0.0
nareshagarwal23

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.

$77 USD in 2 dias
(1 Comentário)
0.0