Move Column to Next Tab

C

Cell Block

Hi,

I've seen a lot of posts about moving rows to the next tab, but none o
columns. I have tried changing code from rows to columns, but have no
been able to get anything to work.

Based on a data validation cell being changed from "Active" t
"Inactive" in Row 3 of the column, I would like any column changed t
Inactive to be moved to the next tab, a sheet is named "Archive".
First column is F, and range is F2:F1202, if that helps.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top