Hello Guys, I am new to excel and vba. Doing google since last 15 days to get solution on below issue.
I have 2 sheets. 1. Ongoing and 2. Closed.
Ongoing sheet - Contains Excel TABLE1 having certain columns. one of them is "Status". I have created drop down list with 3 options, open, closed and on hold.
Closed sheet - Contains exactly similar TABLE2 with no data.
I am trying to get create a Worksheet Change event which would,
1. Copy the row from TABLE1 to last row in TABLE2 only when "Status" column in TABLE1 is changed to "Closed".
2. Delete the copied row from TABLE1
3. Shift/Move the rest of the rows above in TABLE1
I tried using below code but getting an error, "Method or Data Member not found" for ListObject("tbl_Closed"). I want to avoid use of cell references and trying to make fully dynamic by using table references. For reference attching the sheet.
Please Login or Register to view this content.
Bookmarks