I have an Excel file and need the following. There are two tabs (sheets) in one Excel file, the first tab in column C & D show date and time in sheet 2 column A & B show date and time. I want to match up the date and time from sheet 1 (C & D) with sheet two (A & B) and when there is a match, put column C of sheet 2 in column G of sheet 1.
For example Cell C3 & D3 are “2/24/2009” & “15:00” in sheet two that matches with A13 & B13 and so we take C13 from sheet 2 and place it in G3.
I want to be able to replace the cells in sheet 1 and sheet 2 and they should be able to repopulate with correct data.
I don’t know how it’s done. Urgent help needed.