+ Reply to Thread
Results 1 to 2 of 2

Using a master list to fill data on additional sheets in a workbook

  1. #1
    Registered User
    Join Date
    09-27-2011
    Location
    providence RI
    MS-Off Ver
    Excel 2008 Mac
    Posts
    2

    Using a master list to fill data on additional sheets in a workbook

    ok So My task is a liquor inventory sheet for my bar. I want to create a sheet (master price sheet) in my workbook with a list of liquor we carry and the price per unit in separate columns. There are 4 other sheets in my workbook that represent the bars and liquor room and the bottles are listed in the order they appear on the shelves to make things quick at inventory time. My goal is to have the master price sheet with costs from my invoices that will populate my count sheets with cost to calculate value of liquor so I dont have to do it on every sheet manually. The value of liquor is an easy formula that I can and have done no problem but Im stumped on the best way to make my cost sheet work for me. keep in mind no 2 sheets have the liquor in the exact same order. Attached is a partial sample of my sheet so far.inventory sheet sample.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Using a master list to fill data on additional sheets in a workbook

    Hi and welcome to the forum

    If I understand you correctly, try this, copoed down on each sheet
    =VLOOKUP(A2,'PRICE LIST'!$A$2:$B$26,1,0)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Autofill data from 2 sheets to master sheet in a workbook
    By remlap511 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-03-2013, 02:04 PM
  2. Creating a master sheet using data from other sheets in the workbook.
    By Chaos247 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2013, 07:57 AM
  3. [SOLVED] Populate Master Sheet with data from other sheets in workbook...
    By DMA-Pacific in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-18-2013, 01:21 AM
  4. Replies: 8
    Last Post: 12-04-2010, 01:20 PM
  5. Replies: 2
    Last Post: 06-11-2010, 12:58 PM

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