| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
re : How to delete a time range in the raw datas.
Hi there,
I hope someone could help me out on this. Senario : Column A = Date (eg. 3/26/2007) Column B = Time (eg. 7:00:19 AM) I have datas daily.. always starting on at 7am to the next day 7am. Therefore in this data, the data is produced in 3 Shift work. A shift = 7am to 3pm B shift = 3pm to 11pm C shift = 11pm to 7am. I would to have a macro to do the following :- When I want A shift datas, it will delete the B & C shift datas. When I want B shift datas, it will delete the A & C shift datas. When I want C shift datas, it will delete the A & B shift datas. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting datas in one range based on datas in another range | Excel Discussion (Misc queries) | |||
| how to delete datas without deleting formulas | Excel Discussion (Misc queries) | |||
| Run-time error "5" after range().delete runs before querytable.add | Excel Programming | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| re : Finding the datas and deleting datas which are not found. | Excel Programming | |||
Linear Mode
