Results 1 to 11 of 11

Recalling info into another row

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2007
    Posts
    12

    Recalling info into another row

    I am trying to recall info from the rows in another part of a worksheet when I type the first column. For example, I have over 300 rows of:

    Apples 155 12oz red
    Orange 120 10oz orange
    Banana 50 11oz yellow
    etc.

    I want to select or type only the word:

    Apples

    And have the rest of the columns fill in with the rest of the info, like so:

    Apples 155 12oz red

    A filter would work well to select, except I need about 7 in the worksheet as it is a form and excel only allows one. I can’t seem to make the advanced filter work. An IF function would work, except I'd have to put all the words to match in " " marks, which would be very time consuming.

    Anyone have any ideas of how I can recall the info from my list to the 7 lines I need to copy them into??

    Any ideas would be greatly appreciated.

    Thank you!
    Last edited by VBA Noob; 12-19-2007 at 01:43 PM.

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