View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Benijofar Dave Benijofar Dave is offline
external usenet poster
 
Posts: 1
Default macro for searching, copy and paste between sheets

Help please very new to macros.
I need to take users input value from sheet1 and search col A in sheet2 for
the same number, say number 5, then move across row 5, four columns and
insert a date value from sheet1 along with calculated future date value in
column 5. have spent ages trying to do this, but unable to do it in macro.
really would appreciate any help. I´m using excel 2003.