View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon-Henrik Jon-Henrik is offline
external usenet poster
 
Posts: 1
Default comparing data and write values if true

Hi
I have in sheet 1, all the dates of the year 2003 in column B
In sheet 2, i import data from another workbook using a macro
The data from the other workbook contains dates, and they are placed in the column B in sheet 2
If i.e. field B7 in sheet 2 is 13.11.2003, i want to write the values in cells c7,d7,e7,and f7 into the c,d,e,and f cells next to my match of date in column b,sheet1

Can anyone please help me with this

Jon-Henrik