Interesting issue - Retrieving data from another worksheet updating back

[muizac]

Hello,

And thanks for looking at this interesting issue - it has certainly been puzzling me for hours. I've run out of ideas

In the attached worksheet 'input', at row B33 there's an example of the result I'm aiming for. It's to retrieve all bookings from the 'schedule worksheet' that match today's date. And by editing the 'checked in' status field in this input new list (F33 - from N to Y), it's to update the record on the 'schedule' worksheet.

Is this possible?

http://www.ozgrid.com/forum/attachment.php?attachmentid=37433&d=1302016438

Thanks heaps
Andrew

 

[GlennUK]

Cross posted here:

http://www.ozgrid.com/forum/showthread.php?t=152295