Move Column to Next Tab
Hi,
I've seen a lot of posts about moving rows to the next tab, but none on columns. I have tried changing code from rows to columns, but have not been able to get anything to work.
Based on a data validation cell being changed from "Active" to "Inactive" in Row 3 of the column, I would like any column changed to 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!
|