| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search for values to define range
I am trying to write a macro that will search a
spreadsheet for a number in column 1 (for example 1303002 only), and then highlight and copy all the associated data in column 5. Can anyone provide an example? (VLOOKUP is not desireable for this task.) Thank you. Element LC Nx Ny Nxy 1303001 6 -9218 0 518 1303002 1 -8645 0 227 1303002 2 -9141 0 205 1303002 3 -8102 0 448 1303002 4 -8719 0 192 1303002 5 -15747 0 613 1303002 6 -15661 0 509 1303003 etc... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search from range in column 1 and print from corresponding values | Excel Discussion (Misc queries) | |||
| How to define range of values in a formula? | Excel Worksheet Functions | |||
| dynamic search in the Define Name window | Excel Discussion (Misc queries) | |||
| How do I define a range using values in cells? | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Threaded Mode
