I need help... before I either cry or drink myself into a stupor :-/
I found this awesome awesome code on contextures which does pretty much exactly what I need for a large data report for a NFP organisation that I work for, it's called AdvFilterCities.
It works for me because there are a dozen or so managers all wanting input into the structure of this report, and the fields that are included/excluded are inevitably changed on an almost daily basis
My problem is, if on my master sheet (which I am using as the "template") I have all of my data validation set up, when I use the macro, the data validation doesn't get copied to the individual sheets.
Unfortunately the data validation is super important, because the managers here apparently cannot grasp the concept of what accumulative totals are, are in one quarter may put a figure of 67, and in the next put 43.
Please please please can someone help?????
I found this awesome awesome code on contextures which does pretty much exactly what I need for a large data report for a NFP organisation that I work for, it's called AdvFilterCities.
It works for me because there are a dozen or so managers all wanting input into the structure of this report, and the fields that are included/excluded are inevitably changed on an almost daily basis
My problem is, if on my master sheet (which I am using as the "template") I have all of my data validation set up, when I use the macro, the data validation doesn't get copied to the individual sheets.
Unfortunately the data validation is super important, because the managers here apparently cannot grasp the concept of what accumulative totals are, are in one quarter may put a figure of 67, and in the next put 43.
Please please please can someone help?????
