Hi I am hoping someone can help me.
I want to create a macro that when activated will look down a column of dates in sheet 2 and when it finds one that matches a date entered into cell a1 in sheet 1 it will paste a range of data from sheet 1 c11:m11 into the cells next to the date in sheet 2.
Very grateful for any help
I want to create a macro that when activated will look down a column of dates in sheet 2 and when it finds one that matches a date entered into cell a1 in sheet 1 it will paste a range of data from sheet 1 c11:m11 into the cells next to the date in sheet 2.
Very grateful for any help