The attached spreadsheet has 2 tabs - Open and Closed. I'm trying to write a macro that takes any row on the Open tab that has a date in the "Date Closed" column and move it to the Closed tab. As the macro is currently written, it moves any row regardless of if there is a closed date.
Hi sbrnard
I'd probably take a different approach (AutoFilter perhaps) however, existing Code works with the indicated change...
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Attach this code to your close button:
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi sbrnard
Check that...the Code I provided will work only is the narrowest of conditions...
You need to step backward through the cells as alansidman suggests.
Hi sbrnard
I'd still suggest Auto Filter as an approach rather than looping through the Cells. However, you're welcome. Thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks