Is there a program or method to merge multiple Excel files, I get
about 14 sales reports each month , each with the same header layout
data, and would like an easy method to merge them into one spreadsheet.
I would like ot do this without copying and pasting from each file to
the master file.
Thanks for any help.
Regards,
Tony
Bob Greenblatt - 31 Aug 2005 15:11 GMT
Check out help on "Consolidate". This will probably do what you want.
On 8/30/05 5:56 PM, in article
1125438990.273546.271950@g44g2000cwa.googlegroups.com, "Tony Gann"
<tonygann@mac.com> wrote:
> Is there a program or method to merge multiple Excel files, I get
> about 14 sales reports each month , each with the same header layout
[quoted text clipped - 6 lines]
> Regards,
> Tony

Signature
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom