tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
In column A i have date of sale
in column B I have time of sale (e.g. 13:00:00)
in column D i have number of sales
in cell G7 I have the highest sale of the week
i'd like a macro that when i click on the cell it tells me when this sale happened
so in simple terms i'd like this,
I click on cell G7,
it takes the value in G7 and looks down ColumnD to try find it,
if it finds it it brings up a message box saying
"Sale Happened on:"
"Then the Date it Happen and the time it happened"
e.g "12/04/2023 at 13:59:00"
please help if you can,
thanks
Tony
In column A i have date of sale
in column B I have time of sale (e.g. 13:00:00)
in column D i have number of sales
in cell G7 I have the highest sale of the week
i'd like a macro that when i click on the cell it tells me when this sale happened
so in simple terms i'd like this,
I click on cell G7,
it takes the value in G7 and looks down ColumnD to try find it,
if it finds it it brings up a message box saying
"Sale Happened on:"
"Then the Date it Happen and the time it happened"
e.g "12/04/2023 at 13:59:00"
please help if you can,
thanks
Tony