I have several worksheets coming from several users that I need to combine.
The problem is they will all be sending them in separately as there is no
shared drive for them to save to. In total there will be about 130
worksheets with sales data on it.

Is there a quick way of combining all of them into one?

Any help appreciated

Fawn

How and where are they being sent? By email? If so, what program and
version?

What do you mean by "combine"? Consolidate the data, or just appending
each worksheet together into one super worksheet?

What operating system are we talking about? Vista? XP? Something else?

Details please.

--JP


On Sep 4, 10:08*pm, "Fawn" wrote:
I have several worksheets coming from several users that I need to combine.
The problem is they will all be sending them in separately as there is no
shared drive for them to save to. *In total there will be about 130
worksheets with sales data on it.

Is there a quick way of combining all of them into one?

Any help appreciated

Fawn

They will be sent by email and using excel 2007 version. I want to append it
all to one worksheet Operating system is XP

thanks


"JP" wrote in message
...
How and where are they being sent? By email? If so, what program and
version?

What do you mean by "combine"? Consolidate the data, or just appending
each worksheet together into one super worksheet?

What operating system are we talking about? Vista? XP? Something else?

Details please.

--JP


On Sep 4, 10:08 pm, "Fawn" wrote:
I have several worksheets coming from several users that I need to
combine.
The problem is they will all be sending them in separately as there is no
shared drive for them to save to. In total there will be about 130
worksheets with sales data on it.

Is there a quick way of combining all of them into one?

Any help appreciated

Fawn

You could use the code from this site to save all of the attachments:

http://www.codeforexcelandoutlook.co...ltiple-emails/

And there is code here that will let you combine the workbooks:

http://msdn.microsoft.com/en-us/library/cc837974.aspx


HTH,
JP


On Sep 5, 10:23*am, "Fawn" wrote:
They will be sent by email and using excel 2007 version. I want to append it
all to one worksheet Operating system is XP

thanks

"JP" wrote in message

...
How and where are they being sent? By email? If so, what program and
version?

What do you mean by "combine"? Consolidate the data, or just appending
each worksheet together into one super worksheet?

What operating system are we talking about? Vista? XP? Something else?

Details please.

--JP

On Sep 4, 10:08 pm, "Fawn" wrote:



I have several worksheets coming from several users that I need to
combine.
The problem is they will all be sending them in separately as there is no
shared drive for them to save to. In total there will be about 130
worksheets with sales data on it.

Is there a quick way of combining all of them into one?

Any help appreciated

Fawn- Hide quoted text -

- Show quoted text -

Hi Fawn

See
http://www.rondebruin.nl/mail/folder2/saveatt.htm

There is code on my site and a add-in
See also the link Jp posted to my MSDN article

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Fawn" wrote in message ...
I have several worksheets coming from several users that I need to combine.
The problem is they will all be sending them in separately as there is no
shared drive for them to save to. In total there will be about 130
worksheets with sales data on it.

Is there a quick way of combining all of them into one?

Any help appreciated

Fawn

Thanks Ron.

--JP

On Sep 5, 11:49*am, "Ron de Bruin" wrote:
Hi Fawn

Seehttp://www.rondebruin.nl/mail/folder2/saveatt.htm

There is code on my site and a add-in
See also the link Jp posted to my MSDN article

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Fawn" wrote in . ..
I have several worksheets coming from several users that I need to combine.
The problem is they will all be sending them in separately as there is no
shared drive for them to save to. *In total there will be about 130
worksheets with sales data on it.

Is there a quick way of combining all of them into one?

Any help appreciated

Fawn