Pull Data from Multiple Workbooks

**prashantpradhan** · 06-07-2012, 06:02 PM

Hi,
I am the sales manager of a telecom company and every weekend my sales staff sends me a sales tracker
Untitled.jpg

I have 46 staffs sending me an attachment and its very tiresome work to copy and paste all the 46 sheets.
Can you provide me with a macro by which a press of a button will allow me to Pull the data from those sheets delete it automatically so I dont have a mess saving them in the desktop and finally save it in Master workbook.
Also all the attachment comes with a same file name "Sales Tracker.xlsx" and SalesTracker sheet.

Thanks in advance

**NU2vba** · 06-07-2012, 06:47 PM

Hello,

Have you tried sharing the workbook? See link below.

http://excel.tips.net/T002916_Sharin..._Workbook.html

**arlu1201** · 06-08-2012, 06:34 AM

First of all, you should attach a sample excel sheet not a png file. You can remove all sensitive data and then upload.

Also, what mail software are you using - Outlook or gmail, yahoo, etc?
If its outlook, you can have a macro that opens up each email received, opens the attachment, consolidates the data, closes the attachment and proceeds to the next one.

Alternatively, you can also save each attachment in 1 folder on your system, have the macro compile these sheets and then delete the files for you.

**prashantpradhan** · 06-08-2012, 06:21 PM

Sales Tracker.xlsx

Dear arlu1201
pls check the attachment. i use outlook application. generally the attachments are of same file name.
if i save those files in one folder it will overwrite each other. csn u suggest the macro code or programme to be precise.

thanks

**prashantpradhan** · 06-09-2012, 05:59 PM

Dear All,

I Copied this Code from here and there but its not working somehow,

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The scenario is this..I want the Master workbook to copy from diffrent workbook from specific Sheet A2:G505 saved in sub folders each. Each Workbook saved will be copied in the master workbook same sheet one after another. is it necessary to wite each files formula in the Master Workbook? e.g.

1 Activity.xslm C:\Users\EloisePranabika\Desktop\Projects\Paul_Wall $A$2 $F$505 MasterData $A$2:$A$505
2 Activity.xslm C:\Users\EloisePranabika\Desktop\Projects\Hrides $A$1 $H$50 Master Data $A$2:$A$505
3 Activity.xslm C:\Users\EloisePranabika\Desktop\Projects\Sam $A$1 $H$50 Master Data $A$2:$A$505

Please help me I am in a Deadline................

**arlu1201** · 06-14-2012, 11:04 AM

So do you want the macro to be in outlook? or in excel?

Once upon a time i used to use a macro that was in excel but used to retrieve files from outlook. It will take me sometime to search it up.