Hi Ray;
That helps quite a bit.
Do the suppliers have the Raw Data sheet? I assume they do, because the Output sheets need the data on the Raw Data sheet for the descriptive columns.
You say that the suppliers run the macro. Why don't you run it before sending out the file? That way all 3 outputs are already available and they just select the sheet that they want to look at.
If I was doing it, I would put all the output on the Raw Data sheet to the right of the data to count. I would then provide buttons to select one of the outputs to view (all the unselected outputs would be hidden). This would save having to worry about copying formulas or running macros (all the outputs would be formulas, so there would be no macros to run).
I would also include instructions on how to hide the descriptive columns that they don't want to see.
If you want to leave the different outputs on different sheets, then I would create a macro that creates the right # of columns and rows on each of the output sheets. I probably should have included it in the file I uploaded, so here it is:
When you change the # of rows or columns in Raw Data, then just run this macro. It will delete all the data on the output sheets, so you will want to run "Count_Cars" afterwards.
You can have it run every time that Count_Cars runs if you want. Just insert this line inside "Count_Cars"
Bookmarks