Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving Data from another sheet
Hello, I am trying to figure out a way to make a database and I was hoping
someone could help me with a snag I hit. I am trying to create a database in Excel. It will basically have two sheets. One for all of the information, and the other to act as a sort of search function. The sheet with all of the information will have several columns, including a persons name, clothing size, shoe size, etc. What I want on the second sheet it to be able to type the persons name (which will be column A) and be able to search the database and show all of the information in the rest of the columns. (For example, the name in column A2 is Joe and there are three other columns. The search would return all of the information in columns B2, C2 and D2) I know that there is a way to do this, but my experience in programing with Excel is somewhat limited. Is there anyone that can help or at least point me in the right direction? Any help would be greatly appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for retrieving a set of data from excel sheet | Excel Discussion (Misc queries) | |||
Retrieving Data: Speed of beating down rows vs retrieving from array? | Excel Programming | |||
Need help searching another sheet and retrieving a value | Excel Worksheet Functions | |||
retrieving values from a specified sheet | Excel Worksheet Functions | |||
Retrieving data from work sheet to USER FORM | Excel Programming |