View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeremiah Jeremiah is offline
external usenet poster
 
Posts: 49
Default Copy from sheet to sheet when matches criteria

I need to copy values from Col B Sheet2, to Col D Sheet1 only if Col A on
Sheet1 matches Col A on Sheet2 and Col B on Sheet 1 has the text "Year to
Date". The last row and number of rows in between each Year to Date row will
vary each week.