Results 1 to 4 of 4

combing multiple worksheets in a workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-19-2010
    Location
    US
    MS-Off Ver
    Office 365
    Posts
    111

    combing multiple worksheets in a workbook

    I have 2 worksheets I am trying to combine, the first sheet contains a store list of 200 stores, the second worksheet contains a list of 155 products, I need to list each of the 200 stores with all 155 products.

    Is there a formula to do this or an easier way than copying the 155 product list to columns B C D, then copying the first store number to column A, then copying the store number down 155 times, then repeating for second store?

    I have attached a spreadheet, the summary page is where I want all 200 stores with all 155 products listed, I have manually copied over the 1st 2 stores.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-26-2013, 11:20 PM
  2. [SOLVED] Copying Worksheets from Multiple Workbooks to a Single Workbook, Separate Worksheets
    By DHartwig35805 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-27-2012, 11:38 AM
  3. Copying Worksheets from Multiple Workbooks to a Single Workbook, Separate Worksheets
    By Abhi_1977 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2012, 11:32 AM
  4. Combing data from worksheets in a directory.
    By nickm687 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2007, 06:51 AM
  5. Combing source data from 2 worksheets.
    By Monique in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-15-2005, 12:06 AM

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