How to consolidate workbooks automatically from multiple emails?
 

I have a master spreadsheet that is updated every week with additional data.
This data is provided by other users, who email a copy of the master sheet
with selected data entered. This data is then pasted manually to the master
sheet. Can the data be automatically consolidated once the email is sent?
Thanks,

CCSMCA

How to consolidate workbooks automatically from multiple emails?
 

Which mail program do you use



--
Regards Ron de Bruin
http://www.rondebruin.nl


"CCSMCA" wrote in message ...
I have a master spreadsheet that is updated every week with additional data.
This data is provided by other users, who email a copy of the master sheet
with selected data entered. This data is then pasted manually to the master
sheet. Can the data be automatically consolidated once the email is sent?
Thanks,

CCSMCA

How to consolidate workbooks automatically from multiple emails?
 

You can use VBA to automate the process of getting the attachment from the
mail and adding the new data to the master sheet (as long as you're using
Outlook and the format of the incoming sheet is fixed)

Bit of a big project though, so you might want to break your question down
into more manageable chunks.

Tim

--
Tim Williams
Palo Alto, CA


"CCSMCA" wrote in message
...
I have a master spreadsheet that is updated every week with additional
data.
This data is provided by other users, who email a copy of the master sheet
with selected data entered. This data is then pasted manually to the
master
sheet. Can the data be automatically consolidated once the email is sent?
Thanks,

CCSMCA

How to consolidate workbooks automatically from multiple emails?
 

Hi Tim

Also possible in OE, I do this a few times a week.

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
You can use VBA to automate the process of getting the attachment from the
mail and adding the new data to the master sheet (as long as you're using
Outlook and the format of the incoming sheet is fixed)

Bit of a big project though, so you might want to break your question down
into more manageable chunks.

Tim

--
Tim Williams
Palo Alto, CA


"CCSMCA" wrote in message
...
I have a master spreadsheet that is updated every week with additional
data.
This data is provided by other users, who email a copy of the master sheet
with selected data entered. This data is then pasted manually to the
master
sheet. Can the data be automatically consolidated once the email is sent?
Thanks,

CCSMCA

How to consolidate workbooks automatically from multiple email
 

Thanks Guys

"Ron de Bruin" wrote:

Hi Tim

Also possible in OE, I do this a few times a week.

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
You can use VBA to automate the process of getting the attachment from the
mail and adding the new data to the master sheet (as long as you're using
Outlook and the format of the incoming sheet is fixed)

Bit of a big project though, so you might want to break your question down
into more manageable chunks.

Tim

--
Tim Williams
Palo Alto, CA


"CCSMCA" wrote in message
...
I have a master spreadsheet that is updated every week with additional
data.
This data is provided by other users, who email a copy of the master sheet
with selected data entered. This data is then pasted manually to the
master
sheet. Can the data be automatically consolidated once the email is sent?
Thanks,

CCSMCA