Hi,
I'm struggling with the ability to update a summary sheet for each location (each sheet) that i have which collects monthly stats on calls made to a service centre. I have macros that pull out the data and the total calls made per reason for each location and the final step is then to update the summary sheet for each location with the results (source = APR Call Wraps, Destination = Summary Call Wraps).
The sheet for each location (in Summary workbook) has all the possible reasons ( in column N ) that can be used and the call wrap data will contain many of these reasons. The issue I'm having is working out how I view the first cell in the call wrap data (column S6), copy the number in the next column (T6), go and find the same sheet and the same reason in the Summary workbook (column N) and then offset(0, 1) untill it finds the blank cell and then paste in the number from the reasons sheet (column T).
It would then need to go back and move through all the reasons (next row S7...) and populate the values as necessary in the blank cells, then move on to the next sheet.
Hope that is sort of clear. I've attached 2 examples of what I'm trying to achieve.
Bookmarks