Excel, copy and paste column data based on date specified
- by Angela
Cell C1 contains a date.Macro to check the date in C1, if the same date is mentioned in row 3 then copy all matching date data beneath it from D6 downwards, paste to sheet2, cell b3.Also copy a6 column downwards to sheet2, cell a3.