Macro to Export systematically to master spreadsheet

Closed
eol2702
Posts
1
Registration date
Wednesday August 21, 2013
Status
Member
Last seen
August 21, 2013
- Aug 21, 2013 at 05:13 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Aug 22, 2013 at 10:48 AM
Hi Guys,
I'm quite new to excel macros, a little help would be much appreciated!

I am stuck on this problem: every quarter we receive an excel file with large quantities of data (different sheets but in similar format). I need to select the needed data and transfer it manually to specific locations on our master table (different spreadsheet). Is it possible to create a macro that will automatically transfer the data from one table to another? and how to proceed?

Please help me, thanks a lot!

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Aug 22, 2013 at 10:48 AM
Hi eol2702,

Yes it is possible, but with the info you provided it is impossible.

Best regards,
Trowa
0