+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : combining data from multiple worksheets

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    2

    combining data from multiple worksheets

    I have over 100 separate worksheets all within the same workbook. Each worksheet contains a vendor, purchase order, and purchase order amount.

    I want to be able to combine all worksheets into one, arranged by vendor.

    Any help is much appreciated.

    Thank you.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: combining data from multiple worksheets

    Hi bWagner
    Jerry has some good examples here
    https://sites.google.com/a/madrocket...ets-to-1-sheet
    Last edited by pike; 11-11-2011 at 07:46 PM.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1