Results 1 to 5 of 5

Reference multiple and duplicate part cost in one sheet with costs from another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2023
    Location
    London, UK
    MS-Off Ver
    365
    Posts
    3

    Reference multiple and duplicate part cost in one sheet with costs from another sheet

    Hi, please help a newbie!
    I have a "Bill of Materials" sheet with multiple "builds" consisting of part numbers and costs used to create those builds.
    I have a second sheet of "Parts Cost", where the cost is entered.
    How do I associate all the part numbers on the "Bill of Materials" with the cost for that part, on the "Parts Cost"?
    Note, some of the part numbers in the Bill of Materials are duplicated multiple times.
    Basically I want to be able to change the cost of a part in the "Parts Cost" sheet and automatically update all instances of that part cost in the "Bill of Materials" sheet.
    Hope that makes sense.
    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. [SOLVED] Formula to duplicate cell content from multiple columns on one sheet onto separate sheet
    By novicealan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-06-2023, 09:33 AM
  2. Replies: 2
    Last Post: 11-17-2022, 09:30 AM
  3. Finding Cost Per Month with Multiple Date Ranges and Variable Costs
    By gooutside in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2021, 06:17 PM
  4. Replies: 8
    Last Post: 02-20-2021, 01:57 PM
  5. Cell value as part of a reference to another sheet
    By gvaltat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2020, 02:54 PM
  6. [SOLVED] Duplicate sheet but change sheet name and date on multiple rows
    By hambly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2012, 09:39 AM
  7. Replies: 11
    Last Post: 10-16-2008, 05:14 PM

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