| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary sheet showing holiday dates taken
I'm trying to work out a formula to extract dates from a spread sheet and
show them on a summery sheet. Ive set up a sheet that has 12 tabs one for each month, in each sheet there are names down the side (A4 to A98) and the dates along the top (D4 to AH4). I then enter a "H" in the appropiate cell when they take holidays. What i would like if possible is to have a formula or macro that colates all the dates when holidays are taken and displays in the summery sheet similar to below Holidays Taken 1 2 3 4 5 6 7 J Bloggs 02-Jan 05-May 06-Jul 08-Aug 09-Sep Can anyone help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
| Daily Totals on a summary sheet | Excel Worksheet Functions | |||
| I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
