I might have to type allot to explain so bear with me please.
2 sheets one called "LOG" the other "Time & Duty"
Sheet Time & Duty. extracts information from the sheet log and inserts the information based on Dates from sheet LOG,
the dates column on both these sheets are in COL A.
Sheet log has 1500 rows and will be expanding every day I work, so the dates are not 7 days a week.
now sheet time
and duty I have a drop down in a1 that you choose which month and year i want to display. So if I choose this month it will
only show the dates from the 1st till the 30th and extract the correct rows that represent the dates from the LOG sheet,
(then insert the information from col b to col z. (onto the sheet time and duty).
Now I have all this for work and
the days I do not work, if it sees if there is no similar date from the time and duty sheet to the Log sheet it will enter
and "OFF' on the time and duty sheet. Example B3 below
Now if I insert a range of dates that are on the sheet time and duty, how can I get e.g. B3 to first check the LOG sheet
then reference the Time and duty sheet where the range of dates are, if the dates also fall into the range of dates on time
and duty sheet I would like the columns (and receptive row) to show "VACATION" I put the range from cell "a45:c50"
4/8/08 6/3/08 work
6/3/08 7/1/08 vacation
7/1/08 8/26/08 work
8/26/08 9/23/08 vacation
9/23/08 11/18/08 work
11/18/08 12/16/08 vacation
If you are still here congratulations, and thank you for your time.