Results 1 to 2 of 2

Thread: How do I propagate one worksheet with multiple pieces of data from another worksheet?

  1. #1

    How do I propagate one worksheet with multiple pieces of data from another worksheet?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am creating a form that requires NAME, ADDRESS, PHONE.

    I have a worksheet with all of the necessary data. Each piece is within its own cell.

    I like the idea of a Drop Down where I select the NAME and all of the other data follows.

    I understand how to create a Drop Down and achieve single cell input, but that's where it ends.


    Can anyone guide me to sucess?


    Congo3

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    No need to start a new thread. You can post to the old one to "bump it" if you felt it wasn't getting attention. (Sorry, I was sick yesterday.)

    http://www.excelguru.ca/forums/showt...ther-worksheet
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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