Thread: Cut and Paste range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Crowbar via OfficeKB.com Crowbar via OfficeKB.com is offline
external usenet poster
  
Posts: 128
Default Cut and Paste range
Hi All

I have data in column A that says JN or HR or CH

I want Excel to identify all data in column A and paste the data into a
different sheet

i.e All data that starts with JN in column A will be pasted into a JN sheet
and all data that starts HR will go ito a sheet called HR

Any Ideas??

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1
Reply With QuoteReply With Quote