Hi Toppers,

Let say I was entering a hotel booking on to an excell sheet and I wanted to
use the data to check whether a room is a valiable , which is on another
Excell sheet. Imagine I want to check if the data for the booking, and I have
entered the date on a sheet, I want an automated method of checking this data
against the master sheet, which has all the bookings.

"Toppers" wrote:

A clearer explanation is needed: what do you mean by "fits in" to the Master.

An example of the data and "fit" would help.

"Pawan" wrote:

I am trying to find out that if I had entered data on one sheet, and I want
to see how the data fits in to the "master sheet". Is there any way I can do
this?