Dear All,
I have the following names in a row like below
<tbody>
</tbody>
and I have a table on another sheet where I have the following data,
<!-- Please do not remove this header -->
<tbody>
</tbody>
As a result in the next column cell I need the name of the highest aged person and in next column cell his age.
as in this case
<tbody>
</tbody>
There is around 2000 rows everyday and Presently I am doing it manually.
If I get a VBA code it would save me a lot of work.
Thanks in Advance
Jack
I have the following names in a row like below
Sam | John | Jack | George Paul | Mathew Joy |
<tbody>
</tbody>
and I have a table on another sheet where I have the following data,
<!-- Please do not remove this header -->
Sam | 45 |
John | 60 |
Jack | 30 |
George Paul | 85 |
Mathew Joy | 32 |
<tbody>
</tbody>
As a result in the next column cell I need the name of the highest aged person and in next column cell his age.
as in this case
George Paul | 85 |
<tbody>
</tbody>
There is around 2000 rows everyday and Presently I am doing it manually.
If I get a VBA code it would save me a lot of work.
Thanks in Advance
Jack