Sending Data between two excel files

**jmagomez** · 04-01-2013, 01:53 PM

Dear Fellows,

My goal is to send the data from file comercializacao_fev_2013_região_resultados_macro to the file GN_por Estados_Regiao in the corresponding month of February, per segment.

Could you help me developing a macro to do this job? I sent the two files.

And this macro could have some flexibility? Because I wanted that when I had comercializacao_mar_2013_região_resultados_macro the file, the macro developed to transfer the data in the corresponding month of March to file GN_por Estados_Região, by segment.

Best Regards, Joseph.

**arlu1201** · 04-01-2013, 02:27 PM

I have an issue with zip files on my system. Can you please upload the files directly? Also, you do not need to upload the original files, just sample files will do.

**jmagomez** · 04-01-2013, 05:13 PM

Hello Arlu,

I am sending the files. But the file GN_por Estados_Regiao is above 1 MB limit of forum's messages. How could I send you the file?

Best Regards,

Joseph.

**arlu1201** · 04-29-2013, 05:50 AM

You do not need to send me the original file. Just a sample file containing the same format as the original file will do. You can remove the confidential data.

**jmagomez** · 05-01-2013, 01:48 PM

Hello Arlu,

Thanks for your help. But there is no confidential numbers, I can send you both files. Do you have an e-mail?

I've tried to post at sendspace, but the limit is 300mb.

Best regards, Jose.

**arlu1201** · 05-01-2013, 01:55 PM

You can upload a sample of your original file here. Ensure that the format matches the original file.

**jmagomez** · 05-02-2013, 10:34 PM

Dear Arlu,

I have made some changes at both files, but I am maintaining the spirit of the file.

I wanna send the data from file comercializacao_fev_2013_região_resultados_macro_original to the file GN_por Estados_Regiao_original in the corresponding month of February, per segment, to the same state (the “sigla” column).

And this macro could have some flexibility? Because I wanted that when I had comercializacao_mar_2013_região_resultados_macro_original file, the macro developed to transfer the data in the corresponding month of March to file GN_por Estados_Região, by segment, to the same state (the “sigla” column).

Best Regards, Jose.