retain & add

[Trevor3007]

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

 

[James006]

Hello,

How do you currently input a repeated request such #2663 ...?

 

[Trevor3007]

Hello,

How do you currently input a repeated request such #2663 ...?

good evening 006 ,

thanks for getting back to me.

#2663 is triggered from the =if statement ( as shown in my orig post on a worksheet1.

Also I forgot to include that i needed to 'autosort' otherwise it will leave spaces as the 'request' are
always in order .

Hope this makes sense & thank you
Trevor3007