Copy certain columns of data to new worksheet based on two columns.

Hey All,

I am trying to setup a spreadsheet to fill out a document based on two criteria.
This is similar to Advanced Filter but when I use advanced filter it messes up the layout of the second worksheet.

On the first Worksheet I have a list of data .Which is vehicle information.
On the second worksheet I have a printable document that lists only certain columns from the first worksheet based on two criteria.

The problem is that the advanced filter messes up the page styling I have. It messes up the lettering I have at the bottom of the page. Is there a better way to do this that will not mess up my page?

Thanks,
Joe

Hey Dave,

No VLookup won't work I need a bunch of data returned. Just like how advanced filter works.

Joe

hi, jpecor2, it would be helpful to see the sample workbook with original data and the result you need to obtain