Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / August 2005



Tip: Looking for answers? Try searching our database.

Merging Excel Worksheets

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tony Gann - 30 Aug 2005 22:56 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.