Engineering: Creating a Master List from a Print Database

[theclipper]

I have a large Excel 07 File based upon unique Print #s. Each print # may have one or more "details" line items (rows) associated with the print. Each print # also has several column fields.

I need to create a "Master List" pulling from my Print # database. Ideally, I would click in the first cell of a new master list and type in the unique print #. If that print # is found in the database, all associated rows and columns would be "copied over" to the master list. I could then go down to the next available row in my master list, click on the first cell and repeat.

I have researched the web and can't seem to find an efficient way to accomplish this. Thank you in advance for helping!

 

[AFPathfinder]

Sounds like you would need a For loop to define a single Print # on each pass and then filters a column to find matching Print #s on the "detail" rows to copy to a master list. That would be very inefficient on a large file, but could speed it up if we knew more specifically how the data is setup. Can you provide an example?

 

[theclipper]

AFPathfinder, thank you so much for the time and effort. We are thrilled with your VBA solution.