Thread: Copying specific data from Sheet 1 to Sheet 2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jock Jock is offline
external usenet poster
  
Posts: 440
Default Copying specific data from Sheet 1 to Sheet 2
In Sheet 1, when "CH" is selected from a drop down list in column M, I'd like
Excel to copy data from cells B-L from the same line and paste the values
(not formats or formulae) into the next available row in Sheet 2.
Can this be done?
--
Traa Dy Liooar

Jock
Reply With QuoteReply With Quote