Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: pick from list

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

    Default

    on my project i have an invoice, and there is a place for customer address, and oon another sheet i have all the members details,
    how can i transfer the members name, address etc onto the invoice by picking from a list?

    Please help me, as i am nearly on the verge of suicide

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I just thought I'll reply we have one less poster on Mr.excel.

    I am able to help you with a code I have written.Please give me a chance to search my Laptop.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi no need to get to worked up, sure i can guide you a little... VBA not needed.

    Lokk set a client num,ber in the customer records say Col A if A used inset to left making A now B and A all new / blank.

    ID the rows of data.

    Now inv sheet.

    put customer number above address and vlookup the next few rows of address and then, the data will transfer by linking the user number o the inv sheet to the inv no in the data sheet.

    try:

    =VLOOKUP(A3,'Data sheet'!A1:D10,3,0)

    This wil be in the Invoice sheet

    See the 3 this needs changing to 3 4 5 6 whatever..


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

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
  •