tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Ok so I have a sheet called "All Data"
in here I have a
list of names in column C
Identifyer in Column A
And the Date or the word "Time" in column B
so heres what i want in sheet "Input" cell D10 i have a Name, (this name can appear more than once in column C),
So I need the macro to go look for the name in column C and find the Row that has the earliest date for that name,
and input the row number into Inputsheet D12
please help if you can
Thanks
Tony
Ok so I have a sheet called "All Data"
in here I have a
list of names in column C
Identifyer in Column A
And the Date or the word "Time" in column B
so heres what i want in sheet "Input" cell D10 i have a Name, (this name can appear more than once in column C),
So I need the macro to go look for the name in column C and find the Row that has the earliest date for that name,
and input the row number into Inputsheet D12
please help if you can
Thanks
Tony