Hello,
I had a question that I was hoping to get some help with.
I have a spreadsheet that has dates in Column A and dates in Column J.
I would like to Match the Dates in Column J with the dates in Column A. When the match is found, I would like the contents of the Adjacent cells to matching-date-cell in Column J (Namely K,L,M,N and O) to be be entered into the Adjacent Cells of matching-date-cell of Column A (Namely B,C,D,E and F).
Example 1: Cell J1's Date is 9/7/1971 and Cell A1's date is 9/7/1971, so I would like the contents of cells K1,L1,M1,N1 and O1 to be placed in cells B1,C1,D1,E1 and F1.
Example 2; Cell J12 has the date 9/22/1971 and BOTH Cells A18 and A19 also have the date 9/22/1971, so I would like the contents of cells K12,L12,M12,N12 and O12 to be placed in cells B18,C18,D18,E18 and F18 AND B19,C19,D19,E19 and F19.
My spreadsheet I am working with is quite large and includes data in 33,607 Rows of Column A and 11,604 Rows in Columns J,K,L,M,N and O.
Thank you in advance for any insight you can give.
I had a question that I was hoping to get some help with.
I have a spreadsheet that has dates in Column A and dates in Column J.
I would like to Match the Dates in Column J with the dates in Column A. When the match is found, I would like the contents of the Adjacent cells to matching-date-cell in Column J (Namely K,L,M,N and O) to be be entered into the Adjacent Cells of matching-date-cell of Column A (Namely B,C,D,E and F).
Example 1: Cell J1's Date is 9/7/1971 and Cell A1's date is 9/7/1971, so I would like the contents of cells K1,L1,M1,N1 and O1 to be placed in cells B1,C1,D1,E1 and F1.
Example 2; Cell J12 has the date 9/22/1971 and BOTH Cells A18 and A19 also have the date 9/22/1971, so I would like the contents of cells K12,L12,M12,N12 and O12 to be placed in cells B18,C18,D18,E18 and F18 AND B19,C19,D19,E19 and F19.
My spreadsheet I am working with is quite large and includes data in 33,607 Rows of Column A and 11,604 Rows in Columns J,K,L,M,N and O.
Thank you in advance for any insight you can give.
Last edited: