|
Posted to microsoft.public.excel.programming
|
|
|
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
|