Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro
i have many data of shipment date of some products, the shipment date may
from 01/01/2006 to 31/12/2006. and now i only want the worksheet to show those rows which ship date is from 01/04/2006 to 30/06/2006. someone told me can use macro to make it but i can't figure out how to do. thx very much. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro
Macros will do this but have you tried using filter. If your worksheet has
all of the shipment dates in one column then this should work fine. Select the column headers and the DataFilterAutoFilter. Use the drop down box on Shipment date and then select custom and you can apply the filter that you wish to use. Ian "yetshin" wrote: i have many data of shipment date of some products, the shipment date may from 01/01/2006 to 31/12/2006. and now i only want the worksheet to show those rows which ship date is from 01/04/2006 to 30/06/2006. someone told me can use macro to make it but i can't figure out how to do. thx very much. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro
ya i tink tat will do when i add another column of "month" beside my "date"
column, and fill in all the month accoding to the date, then do the auto filter to the "month" column. but my data are all in date form, eg. 21-Mar-06, 12-Dec-06, etc. then i not sure custom can do tat. thx. Ian P wrote: Macros will do this but have you tried using filter. If your worksheet has all of the shipment dates in one column then this should work fine. Select the column headers and the DataFilterAutoFilter. Use the drop down box on Shipment date and then select custom and you can apply the filter that you wish to use. Ian i have many data of shipment date of some products, the shipment date may from 01/01/2006 to 31/12/2006. and now i only want the worksheet to show those rows which ship date is from 01/04/2006 to 30/06/2006. someone told me can use macro to make it but i can't figure out how to do. thx very much. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro
as ian say's work fine here try it, i dont think u have to ad any column's :-)
"yetshin" skrev: ya i tink tat will do when i add another column of "month" beside my "date" column, and fill in all the month accoding to the date, then do the auto filter to the "month" column. but my data are all in date form, eg. 21-Mar-06, 12-Dec-06, etc. then i not sure custom can do tat. thx. Ian P wrote: Macros will do this but have you tried using filter. If your worksheet has all of the shipment dates in one column then this should work fine. Select the column headers and the DataFilterAutoFilter. Use the drop down box on Shipment date and then select custom and you can apply the filter that you wish to use. Ian i have many data of shipment date of some products, the shipment date may from 01/01/2006 to 31/12/2006. and now i only want the worksheet to show those rows which ship date is from 01/04/2006 to 30/06/2006. someone told me can use macro to make it but i can't figure out how to do. thx very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |