Posted to microsoft.public.excel.programming

Sarah[_4_] Sarah[_4_] is offline

external usenet poster

Posts: 11

Macro to copy text from ColumnA to B

Need a macro to copy all rows with the text "sh cam" from
column A to column B.
This is an example only shows 3 examples but my excel
spreadsheet has over 2000.

Column A

Jim Glover
sh cam 00-08-74-34-48
Tammy Smith
sh cam 00-75-38-d9-39
Sam Dover
sh cam 00-08-28-23-23

Thanks
Sarah

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Macro to copy text between two different delimeters	[email protected]	New Users to Excel	1	April 6th 07 03:54 PM
copy text from 1 workbook to another by macro	bigdaddy3	Excel Worksheet Functions	0	August 17th 05 06:20 PM
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA	Master	Excel Worksheet Functions	2	July 12th 05 05:03 PM
Macro to delete a text box and copy in new one	Dave	Excel Discussion (Misc queries)	1	February 18th 05 02:02 AM
Macro to copy daily text file	Cheryl[_4_]	Excel Programming	1	May 27th 04 05:46 AM

All times are GMT +1. The time now is 05:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us