| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Pull data from multiple excel sheets
Hi Guys ,
I have 50+ locations .The engineers from respective locations send excel sheets every week . what I do is pull data manually from each sheet and make a consolidated report. Is there any way where in a MACRO pulls data from all these sheets one by one ,depending upon what cell/row range we specify for the target excel sheet and appends in the active worksheet. Any help would be great. Thanks Chinmay |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to Pull data from multiple excel sheets
Hi Chinmaybl
Start here http://www.rondebruin.nl/mail/folder2/saveatt.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Chinmaybl" wrote in message ps.com... Hi Guys , I have 50+ locations .The engineers from respective locations send excel sheets every week . what I do is pull data manually from each sheet and make a consolidated report. Is there any way where in a MACRO pulls data from all these sheets one by one ,depending upon what cell/row range we specify for the target excel sheet and appends in the active worksheet. Any help would be great. Thanks Chinmay |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to Pull data from multiple excel sheets
On Mar 2, 12:46 am, "Ron de Bruin" wrote:
Hi Chinmaybl Start herehttp://www.rondebruin.nl/mail/folder2/saveatt.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "Chinmaybl" wrote in glegroups.com... Hi Guys , I have 50+ locations .The engineers from respective locations send excel sheets every week . what I do is pull data manually from each sheet and make a consolidated report. Is there any way where in a MACRO pulls data from all these sheets one by one ,depending upon what cell/row range we specify for the target excel sheet and appends in the active worksheet. Any help would be great. Thanks Chinmay Hi Ron, That was simply Great....!!!!!!!......Thanks a lot regards Chinmay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to pull in specific data into multiple worksheets in a workb | Excel Discussion (Misc queries) | |||
| Pull Data from multiple sheets | Excel Discussion (Misc queries) | |||
| pull data from multiple sheets with formula referencing a tab name | Excel Discussion (Misc queries) | |||
| Trying to pull data from multiple sheets (and Word docs too) | Excel Discussion (Misc queries) | |||
| pull data from multiple sheets based on input | Excel Worksheet Functions | |||
Linear Mode
