So,
I have an excel file that I'm using to keep track of customer information. The main page has all of the data on the customers and the other pages have the detailed records of every interaction I had with them. The main page only shows the most recent interaction notes.
I'm trying to set it up so that the main page shows the latest notes I took on the customer in the records page so I don't need to type it twice. So far, I've managed to program it so that it checks the latest date of said customer and then tells me the row number of that entry. I want to then take the resulting row number that was the output, and create a formula to copy the data on x row to my main page.
Is there a way to do this?
Here is an example of the formula I'm using to get the number: =MAX(IF(Table3[[#All],[Contact]]="Sample Name",ROW(Table3[[#All],[Encounter Details]])))
Bookmarks