Re: Updating Filtered Dataset from a Different Sheet
Thanks Luke. I'm not a big fan of pivot charts personally so I wanted to avoid them here. They will scare my end users too. Intrigued by the intermediate sheet, mainly as I don't fully understand what you mean. I might already be running something similar so it could be a goer. Mostly interested in the potential for a VBA solution though. It would be cleaner and would run in the background meaning less chance for the end user to accidentally corrupt the sheet. Also I'm running a few routines in the sheet anyway so it feels right.
Any tips or should I get something uploaded?