Hello
I'm trying to cut and paste data into a workbook without having to manually type in the data into each cell. When I copy the data it pastes all along column A.
From column A, I'd like to extract certain data to column H.
Problem: The data is not always in a specific cell, such as listed here (attached) in cell A29. It could be in A27:A32. Is there function that will allow me to search an array for a specific value (in this case a date), extract a value, and input that value into a certain cell, such as the date in H29?
Bookmarks