How do I add rows of data to new worksheet from data dump

Microsoft Excel 2010 - complete product...
August 22, 2015 at 12:50:45
Specs: Windows 7
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][1]][1]

[1]: http://i.stack.imgur.com/HSL7o.jpg

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 ##

[![Formatted Worksheet][2]][2]


[2]: http://i.stack.imgur.com/twXGS.jpg

Thanks for your help in advance.


See More: How do I add rows of data to new worksheet from data dump

Report •


#1
August 23, 2015 at 05:33:57
I'm not quite sure what kind of help you are asking for. Your subject line asks about "adding rows to a new worksheet" yet you posted an image [2] of data that is apparently sorted in some way and formatted with different font sizes and fill colors. In addition, the 2nd contains data that doesn't even appear in the original data set.

What exactly are you asking for help with? Are you asking us to help create that 2nd, formatted sheet or are you asking for help with adding rows to that formatted sheet?

I also don't understand this line:

with a row being created based on the successful criteria of the data.

What does "successful criteria of the data" mean?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question