Hello,
I have a spreadsheet cumulating data from different sources which is then used to dispatch cutomer cases to Customer Service reps (CSRs for short). Each CSR has a sheet containing the data pertaining to their cases where they can add additional notes, formating, file numbers, etc.
I have used a IF(ISERROR...Index...Match...) kind of formula, which worked well enough at first. However, when new cases are attributed to CSRs, the new cases are not added at the bottom of the list, but smack in the middle of it, and all the notes and formating the CSRs do not follow the case they were written with at first (but got pushed down by the new data).
So basically, I need a formula (or a macro) that will work while the workbook is shared, to send data from the main sheet to individual agent sheets (selected on the basis of the "Agent" column, which will contain NULL values), while keeping on the same line the customer case information from the main sheet and additional notes that the agents write. All that in Excel 2003.
I've attached a sample of dummy data (changed all the personal information) which contains my formula that I've used so far. Can anyone help me?
Bookmarks