| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidate multiple workbooks (...and adding new files in the masterworkbook on the fly) | Excel Discussion (Misc queries) | |||
| Consolidate Multiple Workbooks - Excel 2007 | Excel Worksheet Functions | |||
| Consolidate multiple workbooks into a single worksheet | Excel Worksheet Functions | |||
| Consolidate multiple workbooks | Excel Worksheet Functions | |||
| Update multiple workbooks automatically | Excel Worksheet Functions | |||
Linear Mode
