Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 675
- Office Version
- 365
- Platform
- Windows
good day,
I have a workbook with several worksheets, however there is a need to keep a record of repeated requests. For example.
on 25/9/18 I request ID2663 to be re done, but if I do not get a response from the applicable 3rd party and have to request again. This is what I would like to see IE:-
ID Date Time Day
2663 25/9/18 1400 Tuesday
2663 25/9/18 1700 Tuesday.
etc
At present I use:-
=IF(B2>0,Builds!A2,"")
The above is triggered from another worksheet within the same workbook,
I hope this makes sense & is viable to do?
MTIA & KR
Trevor3007
I have a workbook with several worksheets, however there is a need to keep a record of repeated requests. For example.
on 25/9/18 I request ID2663 to be re done, but if I do not get a response from the applicable 3rd party and have to request again. This is what I would like to see IE:-
ID Date Time Day
2663 25/9/18 1400 Tuesday
2663 25/9/18 1700 Tuesday.
etc
At present I use:-
=IF(B2>0,Builds!A2,"")
The above is triggered from another worksheet within the same workbook,
I hope this makes sense & is viable to do?
MTIA & KR
Trevor3007

Last edited: