| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or Formula
Hi,
I need help with a problem. I have a range of cells C6 to I6 tith the date in them Mon to Sun, below these cells I have input in some of the cell an X to mark the days a person is taking a holiday. so Wed, Thurs, Fri the cells below are marked with an X to indicate a holiday, what I am looking to do is report on another sheet the dates of the holiday this person is taking, so it would report 10th, 11th and 12th Feb 2010 in cell A1 to indicate the dates of the holiday. Can anyone help me with this i'm stuck. Many thanks Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| store formula in macro then paste it when macro runs | Excel Programming | |||
| formula or macro to change a formula in muliple spreadsheets | Excel Programming | |||
| use macro to copy formula with value and not formula without value | Excel Programming | |||
| Formula in macro causes macro to fail | Excel Programming | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Threaded Mode
