+ Reply to Thread
Results 1 to 2 of 2

Quoting Tool, Bill of Materials sheet

  1. #1
    Registered User
    Join Date
    02-15-2021
    Location
    Delray Beach, FL
    MS-Off Ver
    Pro Plus 2013
    Posts
    1

    Quoting Tool, Bill of Materials sheet

    I am working on a quoting tool for my own use. I am new to the great powers of Excel. I am a hack and have been reasonably successful with just a little guidance. Till now.
    I want to have a bill of materials sheet that when it is updated it updates a quote sheet.

    The problem is I have 235 lines entered and I don't want bank fields between items.

    Here is just a few lines: File name 3Test Materials.xlsx (174.5 KB)
    I How do I get the data on my Materials sheet to the Quote sheet?

    Thank you in advance.

    Richard
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,556

    Re: Quoting Tool, Bill of Materials sheet

    Hello rtobier and Welcome to Excel Forum.
    Try the following on the Quote sheet:
    For B26 and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For C26 and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For D26 and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For E26 and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Bill of Materials / Macro VBA
    By mervecevik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2018, 08:03 AM
  2. Bill of Materials
    By DennisWA in forum Excel General
    Replies: 7
    Last Post: 11-27-2017, 06:05 PM
  3. bill of materials (BOM) comparison tool which is excel based.
    By SRCF in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2015, 05:18 AM
  4. Turning off bill of material lines in quoting template
    By cheddarthief in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2014, 03:26 PM
  5. Making a value sensitive summary page for quoting materials
    By mkerfoot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 09:50 AM
  6. Bill of Materials
    By tonyhindmarsh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2007, 05:37 AM
  7. bill of materials
    By stevekirk in forum Excel General
    Replies: 7
    Last Post: 12-10-2006, 05:12 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