View Single Post
 
Old 12-13-2017, 08:20 AM
meowmeow meowmeow is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2017
Posts: 7
meowmeow is on a distinguished road
Default

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,
Attached Files
File Type: xlsm Example workflow tracker.xlsm (19.7 KB, 13 views)
Reply With Quote