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!
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!