hlookup over multiple sheets

[Rob-WNS]

Hi

I have a holiday chart with employees in A3:A500 and 12 other sheets from
January : December with the days that they have off.

I want to create a new spreed sheet where I can set a date and see who is
off in that week, I would like to use Hlookup over multiple work sheets yet
not sure if this can be done.

Each day has a full date so that H lookup can scan the info and I can
forexample then get it to look up row 5 of one day and advise if there is a
'H' in that cell.

I would hope to end up with: 7 columbs for each day of the selected week
showing all employees and any holiday they have, Also a further 7 columns
which show Sickness.

I noted the THREED option yet I think it will not work for this many cells
365 x 500!

Many thanks in advance.

Please note the work is being done in another spread sheet which would link
to the absence spread sheet.

 

[little_creature]

You can use autofilter
Go to data>filter>autofilter>ok
And to see the people who have holiday form to just clik the arrow at the
filter (at the cell) and pick CUSTOM and enter is grater than ... And is
less or equal than

 

[Rob-WNS]

Thanks,

Although the filter is useful, I need to be able to automate the find with a
formula. Can excel do this?

Many Thanks