+ Reply to Thread
Results 1 to 2 of 2

Creating a Quote from a Parts List

  1. #1
    Registered User
    Join Date
    09-26-2019
    Location
    Whitehouse, NJ
    MS-Off Ver
    2016
    Posts
    1

    Creating a Quote from a Parts List

    Hoping someone can point me into the right direction. As of right now everything we do in our company is copy and paste when creating a quote for our customers. I have worked up a Vlookup so when the Qty is inserted on the SMN sheet that it shows up on the unit to build sheet. Is there a way to automatically add a row on the Unit to build sheet with the formulas when the Qty is insert and deleted when its taken out? Or another way to get to my goal?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,630

    Re: Creating a Quote from a Parts List

    Formula for Sheet SMN cell A5 then fill down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula for Sheet Unit to Build cell A17 then fill down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula for Sheet Unit to Build cell B17 then fill down and Right to Cell F23:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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