Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting part of a spredsheet based on the date
I currently have a spreadsheet with all our employees down the A column
and then going across the top a calender. One column per day of the year (it has to go over 2 spreadsheets). I then have a code that is input in the grid to say what dates each employee is on holiday. I am looking for a way to link another spreadsheet to this one, but only show the columns relating to the current month and next month. I can link in the first column with the employee's name as it is static, but how do I get it to link only to this month and next month when it changes each month? I hope this makes sense. Regards Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting part of a cell | Excel Worksheet Functions | |||
Extracting part of data | Excel Discussion (Misc queries) | |||
Extracting part of a cell | Excel Worksheet Functions | |||
Extracting Part of a Date | Excel Discussion (Misc queries) | |||
extracting part of string value | Excel Programming |