View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Very Basic User Very Basic User is offline
external usenet poster
 
Posts: 53
Default Compare dates to copy data

Help please... How would I get the following to occur. (Sheet 1 cell A1 =
2/22/10 when I run macro, look for 2/22/10 on sheet 2, and copy an area from
sheet 1 to the appropriate area of sheet 2. So each time sheet one date
changes, it copys the same area of sheet one into the correct area of sheet 2
that matches the date.
--
Thank you for your time!
John