Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
move rows from column to column rgawlik New Users to Excel 2 October 24th 07 05:50 PM
numbers in a column and it changes when I move to the next column confused Excel Discussion (Misc queries) 1 August 5th 06 04:46 AM
how to move the cursor to column A after entering data column F tskaiser New Users to Excel 2 April 29th 06 02:28 PM
move contents of column C based on criteria related to column A Debra Excel Discussion (Misc queries) 2 December 27th 05 10:25 PM
Move text from column B to column A Sandy Excel Discussion (Misc queries) 4 August 31st 05 01:41 PM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"