TestPilot87
New Member
- Joined
- Mar 23, 2018
- Messages
- 5
Looking for VBA to automatically move a row of data in a table to another table based on the entry of a completion date in a specific column. Help is appreciated.
Can you explain this more?
You said:
trigger being an entry in the “date complete” column
What column is the date complete column?
Tables have a number of columns so is date complete column column 3 or 4 or 5
I'm not 100 percent on which column because I do not have the file in front of me, but for the sake of discussion 8th column. I could just use a reference to the specific column header in the table instead of knowing what column correct? eg Sheet1.Range("Table4[Date Complete]")