Daily, I export data from an application to an Excel spreadsheet. From that spreadsheet, I copy the data to a workbook on a tab called Daily. I then run a simply macro that reformats the data and sorts it.
From that tab, I want to copy all the rows that match other tabs. So, in column B, the row will be flagged with the target tab name (ProjectA, ProjectB, etc.). So, something like this:
For each (project tab x) For each row n on the Daily tab if Daily!Bn = (project tab x) then copy Daily!Cn:Nn to (project tab x)!A22:m22 copy Daily!Pn to (project tab x)!P22
So, selected columns from each row get moved to the corresponding tab into specific columns. I'm doing that part of it manually now; it only takes 45 minutes, but is very prone to error (especially since I'm must in the process of waking up when I do it).
I have a constraint on the solution: I am not a VBA programmer. I can capture/playback macros, I can do formulas. I'm rubbish at VBA.
Second constraint: I'm leaving the department in a couple of months. I'd like to completely automate this for my successor. But I want to avoid using any VBA programming so that, with a little work, he can adjust when necessary.
Thanks in advance for any help.