DATA IN SHEET 1 ON THE BASE OF SHEET 2

  • Thread starter Thread starter manoj
  • Start date Start date
M

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
 
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.
 
Back
Top