Hi! I am new at VBA and as an excercise I am attempting this challenge. I tried to adapt a pre-existing code to my needs and I believe I have understood each function in my code pretty well, but I did realize the code was originally made 9 years ago, so it may be outdated...
Please Login or Register to view this content.
The code is meant to check if the Status collumn (which is collumn F) of my CurrentTable has the word "PAST" in it. If it does have that word, I want it to copy that row and paste it inside the table PastTable located at a sheet named "PAST". After it pastes the row, I want the original to be deleted.
CONTEXT (in case someone wants to suggest a different method):
In my original file I have a table with lots of Conditional Formatting rules. Whenever we try to copy and paste the row onto a different sheet, the Conditional Formatting rules force their way in there, so the format ends up being a mess. Since we are talking about Tables, you can't Special Paste the data. This is the solution I thought was best to solve this issue.
Bookmarks