軟體:Excel
版本:2007
http://imgur.com/YjeR1cn
如圖,若我想要快速篩選 2016/6/27 - 2016/7/3 這個區間所有的值,
除了一個一個手動點選之外,有什麼快速方法嗎?
一問有沒有快速操作的步驟?
二問若要用VBA實現,程式應該怎麼寫?
感謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 124.219.3.20
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1467681726.A.F81.html
→
07/05 10:26, , 1F
07/05 10:26, 1F
→
07/05 10:44, , 2F
07/05 10:44, 2F
→
07/05 11:04, , 3F
07/05 11:04, 3F
→
07/05 11:14, , 4F
07/05 11:14, 4F
→
07/05 11:14, , 5F
07/05 11:14, 5F
→
07/05 11:14, , 6F
07/05 11:14, 6F
→
07/05 11:14, , 7F
07/05 11:14, 7F
→
07/05 11:19, , 8F
07/05 11:19, 8F
→
07/05 11:36, , 9F
07/05 11:36, 9F
→
07/05 14:01, , 10F
07/05 14:01, 10F
→
07/05 14:02, , 11F
07/05 14:02, 11F
→
07/05 14:24, , 12F
07/05 14:24, 12F
→
07/05 14:30, , 13F
07/05 14:30, 13F
→
07/05 14:30, , 14F
07/05 14:30, 14F
→
07/05 14:31, , 15F
07/05 14:31, 15F
→
07/05 14:31, , 16F
07/05 14:31, 16F
→
07/05 14:33, , 17F
07/05 14:33, 17F
→
07/05 14:40, , 18F
07/05 14:40, 18F
→
07/05 14:41, , 19F
07/05 14:41, 19F
→
07/05 14:41, , 20F
07/05 14:41, 20F