Excel Macros help -

Belloni

Belloni

Belloni

Soldato
Joined
17 Feb 2009
Posts
3,001
Hi guys, need something doing for work.

Basically, we have a main spreadsheet where I want to collate data from 4 different work sheets we recieve from other countrys in the exact same format but with their relevant data on it.

I'll be putting their work into a shared drive, how do I create the macro, to read the shared drive, chose the excel file, copy the information needed and paste it into the main spread sheet?

Hope this makes sense!
 
The tables on each sheet will be static, so from cell A129 to I129 I need all the data within that copied to a master sheet.

Where abouts would I enter that into the code? I'm so new to this macro stuff :(
 
You must log in or register to reply here.
Back
Top Bottom