PeterDavids
New Member
Dear All
I am in need of assistance of a macro that copies the contents of a cell in one sheet and then looks for the date intersection in another sheet and pastes the value in the second sheet.
The first sheet contains the data to be copied and the dynamic date for the data.
The second sheet contains a list of dates that needs to be referenced. The cell content from the first sheet has to be copied to the second sheet at the intersection of the dates that match on sheet 1 and sheet 2.
The attached file simulation contains further explanations.
Thanks
Peter
I am in need of assistance of a macro that copies the contents of a cell in one sheet and then looks for the date intersection in another sheet and pastes the value in the second sheet.
The first sheet contains the data to be copied and the dynamic date for the data.
The second sheet contains a list of dates that needs to be referenced. The cell content from the first sheet has to be copied to the second sheet at the intersection of the dates that match on sheet 1 and sheet 2.
The attached file simulation contains further explanations.
Thanks
Peter