Macro to move lines between tabs

Hi all,

I hope you are all well. If you can help with this question it would be appreciated. Is there a way of using macros that will swap a line from one tab on a spreadsheet to another tab on the same spreadsheet based upon if i set a cell to say either open or closed.

I have two tabs (open / closed) in a sheet and am setting up an issue log. The issue is entered in the open tab but when i set the issue to closed i would like the whole line to transfer to the next abailable line in the closed tab.

Many thanks,

Chemist

Wouldn't AutoFilter or a PivotTable be simpler & certainly more efficient?

Originally Posted by royUK

Wouldn't AutoFilter or a PivotTable be simpler & certainly more efficient?

Yes it would. The problem is that I have to use standard documentation that has the two tabs. One to show open issues and one to show closed issues. I was hoping i could find a macro that would stop me having to cut and paste the info between tabs (lazy i know) and would do it automatically when i set the issue to closed? Any ideas if its possible?

Like your avatar by the way

Hi Chemistification;

I'm doing this on the fly without a workbook, so it may not be bug free, but it should give you the idea on how to do it.

Assuming that "Open" and "Closed" are in Column A on Sheet1, and you want the entire row moved to Sheet2.
If these are wrong, just change the column letter and sheet name in the section marked by '******

In sheet1 module (right mouse click sheet1 tab and select "View Code")

Please Login or Register  to view this content.

This will cause the Entire Row to move to Sheet2 as soon as you change Column A to "Closed"

You're welcome. How about rating the answer by clicking the blue scales next to the message # in the upper right corner of the answer you liked