Dear Experts,
I have a set of few macros and a master macro to run all of them this cleans up the data file provided to me by some other department. I run this file and get the desired results. What I want to do is add one macro which will:
Run the set on first sheet after finishing moves on to the second sheet and then third so on and so forth till the last work sheet (Which may vary between 3 to 12)and after cleaning individual sheets it consolidates all individual sheets (lets say called consolidated data).
Currently I am manually running it on the individual sheet and then manually consolidating all the sheets in one place. P.S: After running the macro all the sheets have same headers and same structure.
Best Regards/VKS