Hello All !
I have two sheets. In S1(Sheet1), Cells B4 to AW4 are dates (first day of the month in format mmm-yy), This is a ROW(Row4 in excel). Cells A5 to A140 is exactly the same stuff but this is a column(Column A in excel). In S2, i have 2 columns. Column A is with dates in the same format as in S1, and column B in S2 is some random data.
I want help in a macro that checks the value(a date) of the first cell in S2, (i.e cell A1), copies the entire column B , goes to S1 finds the "INTERSECTING CELL" and pastes the data.
What is the intersecting cell ? It is the cell in S1 with same date in row 4 as in column A. These two dates and the date of Cell A1 in S2 will be same.
I have two sheets. In S1(Sheet1), Cells B4 to AW4 are dates (first day of the month in format mmm-yy), This is a ROW(Row4 in excel). Cells A5 to A140 is exactly the same stuff but this is a column(Column A in excel). In S2, i have 2 columns. Column A is with dates in the same format as in S1, and column B in S2 is some random data.
I want help in a macro that checks the value(a date) of the first cell in S2, (i.e cell A1), copies the entire column B , goes to S1 finds the "INTERSECTING CELL" and pastes the data.
What is the intersecting cell ? It is the cell in S1 with same date in row 4 as in column A. These two dates and the date of Cell A1 in S2 will be same.
