Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Select Macro
Hi All, I've checked around and I think what I need is a macro. I'm not sure if it's a sheet specific macro, or workbook, but I think its sheet. I dont know how to write it though and I was hoping you could help. I have a very large file that has a number of unique id's. Each of these unique id's is located in Sheet1. On Sheet2, the Unique ID appears a a row with detailed information. I would like to be able to click on the unique id in Sheet1 and have it find the ID in Sheet2 and show that information to me. The issue is, as time goes on, more ID's will be added so the a singe cell reference will no suffice, otherwise I would use the Hyperlink function. If at all possible, I would like it to create a temp sheet or show all of the reference data on a blank sheet so it is easy to read. Otherwise, just finding the information in Sheet2 will suffice. Any ideas? -- mkerstei ------------------------------------------------------------------------ mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688 View this thread: http://www.excelforum.com/showthread...hreadid=568130 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Macro to find empty cell and select range to print selected. | Excel Programming | |||
macro to find data and select from active cell to the last row | Excel Programming | |||
Find and Select | Excel Programming | |||
Select other workbook to select data in a macro. | Excel Programming |