|Hello. I am looking for copy data based on criteria into a new work sheet and format it at the same time. My data is a database dump with thousands upon thousands of records and for my purposes I want to create a semi-refreshing excel dashboard that will show the data I want to extract. Basically I am dumping the database to an excel tab but can also access the database so getting to the data is not the problem. What I would like to do is get the data based on criteria and add it to an excel worksheet with a row being created based on the successful criteria of the data.|
Basically my data looks like this:
## DATA FILE TAB ##
[![Data file sample]]
And this is what I want the data to end up looking like. One thing to keep in mind is that I can't simply populate a worksheet as I need to be able to create new rows once "good data" has been filtered.
## Formatted Worksheet ##
Thanks for your help in advance.