treddy1986
New Member
- Joined
- Jan 20, 2014
- Messages
- 4
Hi Friends.
I need help in VBA code for compilation of data.
The need is I receive reports from 20 to 30 sites/ location / companies in a standard format. I.e the site name will be captured in cell 'B2 and the data will be from B3 to B10.
Similar format is for master sheet also where all sites data will be captured i.e B coloumn is for Site1, c coloumn is for site so on to 20 sites.
Now I need to copy paste the data of each site to respective coloumn in master file.
Request some one help me with code to compile by matching the site names.
I need help in VBA code for compilation of data.
The need is I receive reports from 20 to 30 sites/ location / companies in a standard format. I.e the site name will be captured in cell 'B2 and the data will be from B3 to B10.
Similar format is for master sheet also where all sites data will be captured i.e B coloumn is for Site1, c coloumn is for site so on to 20 sites.
Now I need to copy paste the data of each site to respective coloumn in master file.
Request some one help me with code to compile by matching the site names.
