I have two worksheets in one workbook. Results worksheet is named 2024 and data worksheet is named 24D. Column C in worksheet 24D contains dates in those cells. I want the date from each cell in column C to appear in a cell designated for dates on worksheet 2024, based on criteria from column B on worksheet 24D.
On data worksheet 24D, Column B, Row 3, contains the content (or code) of 1STVMC and Column C contains the date of 14Jan24.
On the results worksheet of 2024, I want the date from Column C, Row 3 to appear in Column D, Row 4 on the results worksheet.