View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thomsonpa thomsonpa is offline
external usenet poster
 
Posts: 31
Default copying if value in cell from range of cells

I am looking vor the visual basic code to perform the following action.
I have column "a" with data in every cell, columns "j, k and l 'may have
data in them.

If there is data in j, k or l I want to copy the data from "a" into another
worksheet in column "a", then the data in j, k or l in either b, c or d on
the other worksheet on the same row number as the information in column a.
Since column a has over 120 rows I am looking for a simple solution to this.
Any help in pointing me in the right direction would be helpful.