DATA IN SHEET 1 ON THE BASE OF SHEET 2

[manoj]

I have sheet named Walk In containing details for the customer.
In this sheet, column A named Arrive contains the dates of arrival of
the customer and column C named Depart contains the dates of departure
of the customer.
Column P of this sheet contains Room # in which he stayed.

I also made another sheet named Room List. In this sheet, I have
different Raws with different Room No. and different columns with
different Dates.

In sheet named Room List, I want to put the word "V/D" for the date
which is written in column C of sheet named Walk In. And for the room
no. which is written in column P in sheet named Walk In.

In same sheet named Room List, I also want to put the word "O/D" for
the date start from the date written in column A named Arrive upto
prior the date written in column C named Depart of the sheet named
Walk In. This date should be match with the proper room no. written in
column P of sheet named Walk In.
MOST IMPORTANT: I dont want to pay anything for this advise
please...I can't pay. I need this advise only if I am getting it free
of cost. But if you will help me, it will be great for me. Thank you
very much sir.
Manoj

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.