Trevor3007

Well-known Member
Joined
Jan 26, 2017
Messages
514
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:cool:
 
Last edited:

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Trevor3007

Well-known Member
Joined
Jan 26, 2017
Messages
514
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,533
Messages
5,529,404
Members
409,871
Latest member
i1patrick
Top