Copying over cells from one sheet to the next and deleting orginal cell source

Hey guys

Hope all is well,
I am after some serious help , i been trying to find some solutions and so far i have been defeated every corner i have turned, and hoping you guys and provide the solution

1) Aim – When an issue has been completed on the “Issue tracker” Tab, it automatically copies over to the “completed issues” tab and removes itself from the “Issue Tracker” tab.
To define when an issue has been completed, a close date would be present

The excel sheet might be password protected, if so the password is Miacatalina100

would appreciate any help Available

Regards
D

What column on the Issue Tracker contains the completed?

How is the date entered into that column? Via a formula, data validation, manually?

First things first, on the Completed Issues tab, convert the table back to a range as this messes up establishing the last row.

Next, on the Issue Tracker tab, right click >> view code >> paste code

Now back on Issue Tracker tab, enter a date in the Closed column and it will move to the other tab.

Please Login or Register  to view this content.

Yes please do.

You are very welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.