Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Trying, but to no avail

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to create a customer worksheet with an entire price sheet on 1st page and customer information on the 2nd page. I want to be able to get prices for a job using the price sheet on page 1 without really editing page 1 at all. I have posted before and I've been told to use LOOKUP or VLOOKUP, I am new to all of this and would like more info.

    Basically what my pricesheet has is just 4 columns.
    A Amount of Parts Needed
    B Part Name
    C Part Description
    D Unit Price
    E Extended Price

    Any help would be greatly appreciated.

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    I have a standard database form I can edit a bit and send to you. It will allow you to type in a part description or just the first fe letters or numbers and will bring up the whole list with totals
    Send me your E-Mail
    tstom@hotmail.com
    tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •