I have a workbook with 3 sheets. The first sheet is contact info for applications. The 2nd and 3rd are for Rejected or Accepted applications. I have used Advanced filtering to move over certain info to the applicable sheet when an application is marked Accepted or Rejected.
I had to write a module to update the sheet each time an app is marked Accepted or Rejected. However, I am entering new info on the Accepted and Rejected sheets. When I update the sheets, the extra info I've entered does not stay with the row it is inserted on.
Does anyone know how to keep new data entered with the correct row, when the advanced filter is updated?
I had to write a module to update the sheet each time an app is marked Accepted or Rejected. However, I am entering new info on the Accepted and Rejected sheets. When I update the sheets, the extra info I've entered does not stay with the row it is inserted on.
Does anyone know how to keep new data entered with the correct row, when the advanced filter is updated?