PDA

View Full Version : Solved: Search function VBA



Student1000
05-17-2010, 03:03 PM
Hi,
I would like to find a name stored in "calculations!DE1" in column DA of the same sheet. Then I need to Identify the cell in Column DC that is in the same row as the value found in DA (that is if DA:10 then I need the value stored in DC10). Can anyone tell me how I can do this with VBA?

P.S.
I'm using a sorting macro to identify the top 3 out of 100 data entries, stored in DE1:DE3. I need to Identify the name "Razor1" of e.g. DE1 and search for this name in column DA (the cell where all razor names are stored). Then i need to look up in the same row the value in column DC, in order check how long the battery of that specific razor lasts. This value I need to show the user.

thx for any help in advance. I appreciate your time!

austenr
05-17-2010, 03:11 PM
Can you post your workbook?

Student1000
05-18-2010, 09:26 AM
Thx for your effort but I just solved it myself. Since I am using the sorting macro the top 3 values of a given razor will always be on top. So i just fill a listbox with the top 3 values... but anyways thank you for your interest in helping me.
cheers