View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DanielleVBANewbie DanielleVBANewbie is offline
external usenet poster
 
Posts: 16
Default Copy column to WKst1 from match of wksht 2 and 3

I have a worksbook that has a "Criteria" sheet where the users enter specific
information; A master template that houses all data, and an Internal Project
Plan that is created based on the multiple criteria.

I am new to VBA so I am not sure how to build this.

I need code that says for all rows that match (there is a row ID in column A
and each row has a numeric number), if Cell B50 =60 Copy Column H from Master
Template to column E of the Internal Project plan. The second layer would be
if cell B50=90 copy column J to column E, and the final would be if cell
B50=120 copy column N.

I appreciate any assistance you can provide.
Thanks
--
Danielle :<)