Hi,

Right now, I have a raw data file with some extra columns added to populate extra info I need that doesn't come in the report (I use formulas such as vlookups for this extra info). Off of this data I then run a bunch of pivot tables for all the information I need. Then based off of all these pivot tables, I manually type in the numbers I'm looking for into separate files where I track my metrics. So it's a very manual process. I was wondering if there is a way to somehow automate this or even use a formula to fill in all the information for me on my metric files. (This is for my work. So I did not attach any files.) Can someone let me know if something like this is possible, or if it's not possible. If there is a way maybe I can share some information and take out some of the data you wouldn't need.

Thanks.