Hi,
I am struggling to get a vba macro to work which would move a row from one table to another which is on a different sheet in the same workbook, depending on the value. I will either run this as a worksheet change private sub, or an update button. The workbook attached is a representative workbook due to commercial sensitivity!
It works well so far, but I am trying to get it to only make this check if the active cell is in the table column "Status" . Also, I can work this through without using tables quite easily, however tables work much better in other aspects of the workbook.Please Login or Register to view this content.
The action I have set is to simply select the row, I could work towards copying and deleting the row from the active table although if anyone can give me the full answer I'd really appreciate it!
Bookmarks