| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to read and find a name?
Hi,
Column 1 Sheet1 carries a list of names: David Susan Kathie John etc. Column 1 Sheet2 carries another list: Jack Susan Fred David Sam etc. How do you write a macro to read David in Sheet1 then goes to find it in Sheet2? Perform a task, then returns to Sheet1, comes down 1 row to read Susan and goes back to Sheet2, to find Susan and performs the same task. Repeat the process until it reads a blank name in Sheet1 and stops. Thank you for any help. TIA Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cant find Macro in read only | Excel Discussion (Misc queries) | |||
| Read how to two-way link cells, now can't find the example!? | Excel Worksheet Functions | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
| Find and match totals Genius Req. this should be easier to read | Excel Worksheet Functions | |||
Threaded Mode
