Hey guys, I'm having some issues with a project I'm working on. I'm trying to take data imported into a sheet called "Metrics Prep" and split it into different existing sheets by client. The name of each client reside in column S. The data that needs to be updated for each client only takes one row. For example S2 contains the value "Client ABC" which has a corresponding sheet with the same name. Column T, U, V, and W all contain metrics for the client that need to be migrated to the last row of the respective client sheets with column T in the "Metrics Prep" sheet mapping to column A in each of client sheet, and so on with U-B, V-C, W-D.
Currently I have the following macro:
This code currently executes correctly for the first column. However, when attempting to move down the rows it either moves one cell too far to the left (R3) with the current formula, and doesn't copy the next sheet name, or one cell to the right (T3) and gives me a run time error 9, when I make the following change:
I know this is probably an easy fix that's just slipping by me, but can anyone lend a hand?
Thanks.
Bookmarks