Speed up Delete rows between dates based on cells in another sheet


I have a routine that works but seems to take long. Basically I want to delete any row in the sheet "data" column C that does not fall in the range of the two dates I input in sheet "Dashboard" start date H13 and end date H14



Use an autofilter to identify the rows to remove.






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

The Dalles, Oregon

Image
The Dalles, Oregon From Wikipedia, the free encyclopedia Jump to navigation Jump to search This article is about the city in Oregon. For the nearby geological formation, see Celilo Falls. For other uses, see Dalles. Not to be confused with the town of Dallas, Oregon. City in Wasco County The Dalles City The Dalles and the Columbia River in November 2008 Flag Seal Motto(s):  "Cognito timor Vincit" (Latin), "Knowledge Conquers Fear" (English) Location in Oregon Coordinates: 45°36′4″N 121°10′58″W  /  45.60111°N 121.18278°W  / 45.60111; -121.18278 Coordinates: 45°36′4″N 121°10′58″W  /  45.60111°N 121.18278°W  / 45.60111; -121.18278 County Wasco County Incorporated 1857 Government  • Mayor Stephen Elliott Lawrence (D) [1] [2] Area [3]  • Total 6.61 sq mi (17.12...
Read more

眉山市

Image
Clash Royale CLAN TAG #URR8PPP   关于同名地方，参见：眉山郡、眉山县、眉山专区、眉山地区。 body.skin-minerva .mw-parser-output table.infobox captiontext-align:center 眉山市 三苏祠 简称 眉 地名出处 1.以峨眉山为名、2.城郊有山，分左右两峰，远望如眉，眉山由此而得名，此山现位于眉山电信“6501”单位内部、3.源于苏东坡。据说有人见他眉如山丘，智冠五...
Read more

清晰法令

Image
Clash Royale CLAN TAG #URR8PPP 本條目 部分链接不符合格式手冊規範 。跨語言链接及章節標題等處的链接可能需要清理。 ( 2015年12月11日 ) 請協助改善此條目。參見WP:LINKSTYLE、WP:MOSIW以了解細節。突出显示跨语言链接可以便于检查。 維基百科的法律內容只供參考， 並不能視作專業意見 。任何法律問題應諮詢相關司法管轄權...
Read more