Hi!
I know there are a lot of posts on similar actions of what i need but for some reason im having difficulty (im not versed with macros/vba code) trying to get code to work that others have used on their projects, so i decided to ask for help specifically to my application. Here is the scenario: I have a worksheet that has two tables in it with the same amount of columns in both tables. The amount of rows in both tables are variable. In table 1, I want column K (labeled "Status") to be where i enter "completed" in the cell of a row in that table. Once "completed" is the value of that cell, i want that entire row to be moved down to table 2, below any existing filled rows in table 2. Also i want the rows in table one to shift up and fill the blank space where the row used to be (or maybe just "cutting" the row when it is moved will do that?). Thanks for any help!
I know there are a lot of posts on similar actions of what i need but for some reason im having difficulty (im not versed with macros/vba code) trying to get code to work that others have used on their projects, so i decided to ask for help specifically to my application. Here is the scenario: I have a worksheet that has two tables in it with the same amount of columns in both tables. The amount of rows in both tables are variable. In table 1, I want column K (labeled "Status") to be where i enter "completed" in the cell of a row in that table. Once "completed" is the value of that cell, i want that entire row to be moved down to table 2, below any existing filled rows in table 2. Also i want the rows in table one to shift up and fill the blank space where the row used to be (or maybe just "cutting" the row when it is moved will do that?). Thanks for any help!