View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Wundrfulthing Wundrfulthing is offline
external usenet poster
 
Posts: 2
Default Macro to update information if date changes

using Exel 2000..

I want excel to compare dates on two seperate worksheets and if the date on
the first is greater than the second to insert rows and than copy cells on
the second to different cells also on the second page.

ie..main sheet date is 11-05-08 compared to sheet2 date is 11-04-08...insert
cells at a21:d21 and shift cells down (on sheet2) then copy cells b13:h13 to
a21:b21