Hi NoSparks and others that may be able to help me,
I've been struggling to edit the code to target the table in a different worksheet as opposed to just targeting the range. I read the guides supplied and edited as suggested but I'm assuming that there needs to be extra lines that I have no idea about.
I've supplied a sample of what I am trying to achieve in the attached file.
In the workbook, I have 3 sheets, Triage, Open Tasks, Closed Tasks. It is used to stimulate a workflow, where Triage is where information is keyed in, then travels to Open tasks and Closed tasks when open and closed.
The VBA code cuts and pastes rows automatically, however, it is targeting a range and this is a problem as the information in the open Tasks sheet needs to be in table so that formula and conditional formatting assigned to the table will be duplicated as new entries are moved to Open.
Help would be appreciated in helping to target the Table rather than a range.
Thanks in Advance,
|