i have a list of properties serviced throughout the year. date in sheet
1 column 3 row 4 is for example 01-04-06. date in sheet 1 column 3 row
6 is for example 28-05-06.I am trying to put the 1st date in sheet 2
(april) and 2nd date in sheet 3 (may) HELP--
chusky
------------------------------------------------------------------------
chusky's Profile: www.excelforum.com/member.php...oamp;userid=33077
View this thread: www.excelforum.com/showthread...hreadid=528881You can filter the data, and copy it to another worksheet, either
manually or with programming.
Or, leave all the data on one sheet, and use filters to show specific
records.
There's information on AutoFilters and Advanced Filters in Excel's Help,
and he
www.contextures.com/xladvfilter01.html
www.contextures.com/xlautofilter01.html
chusky wrote:
gt; i have a list of properties serviced throughout the year. date in sheet
gt; 1 column 3 row 4 is for example 01-04-06. date in sheet 1 column 3 row
gt; 6 is for example 28-05-06.I am trying to put the 1st date in sheet 2
gt; (april) and 2nd date in sheet 3 (may) HELP
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
- Jan 24 Wed 2007 20:35
dates
close
全站熱搜
留言列表
發表留言