Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Find a Unique code cut and paste

Hi,
I have a large list of unique alpha numeric codes in an excel worksheet
comprising 25 columns wide by 200,000 rows deep.
I want to enter a list of codes into a worksheet and then the program to
find each code, cut it from the original list and paste it into a seperate
worksheet, so I end up with two worksheets, one containing the original codes
minus the list of codes I have entered, and a second with a list of the
codes removed. I am using excel 2007.
Hope this makes sense.
Thanks
kingie
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
How can I paste a unique values list? jak roodi Excel Discussion (Misc queries) 14 April 22nd 23 08:10 AM
Find Unique Changes Francis Excel Worksheet Functions 2 April 25th 08 04:19 PM
Enhance sumproduct to return unique employee code count Max Excel Worksheet Functions 5 December 4th 07 05:54 PM
Long list, 2 criteria, find unique, paste Howard Leung[_2_] Excel Discussion (Misc queries) 3 March 15th 07 09:40 PM
code not unique find latest date Barbara Wiseman Excel Discussion (Misc queries) 3 December 11th 05 08:50 AM


All times are GMT +1. The time now is 09:19 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"