+ Reply to Thread
Results 1 to 2 of 2

Matching Information Across Worksheets

  1. #1
    Registered User
    Join Date
    03-03-2014
    Location
    Alabama
    MS-Off Ver
    Excel 2013
    Posts
    10

    Matching Information Across Worksheets

    Hello,
    I am experiencing trouble with a monster workbook. Can I ask someone to help me with the following:

    I have a workbook with purchases by quarter (four tabs, each a separate quarter) - total 90,000 lines. Each item purchased is listed in separate rows by date of purchase & quantity per order; therefore, the same item(s) may be listed twice or as many as 20 lines per tab. One column is the item identifier, one column is the item description, one column is the package quantity and one column the package cost. How do I use a single worksheet to locate/list each time the identifier, description & package size match, then count the total quantity purchased per matching items?

    I hope I explained it properly. Thank you for your help
    Barry

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Matching Information Across Worksheets

    Hi and welcome to the forum!

    If you could upload a sample workbook with an example of what you are trying to achieve and your desired results clearly outlined I'm sure we'll be able to help.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 01-31-2014, 09:59 AM
  2. getting information by matching headers and if then look up
    By turbo600hp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2012, 04:38 AM
  3. Replies: 0
    Last Post: 05-27-2012, 07:53 PM
  4. matching information with cells above
    By just_some_guy in forum Excel General
    Replies: 3
    Last Post: 06-20-2011, 04:18 PM
  5. [SOLVED] Matching cell information
    By Wato2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2006, 10:15 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