move row from table to table with cell value within same worksheet

wbstadeli

Board Regular
Joined
Mar 11, 2016
Messages
143
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!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,126,981
Messages
5,621,961
Members
415,869
Latest member
LWSkinner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top