I'm familiar with excel but far from advanced which makes my task at hand a little difficult. I know this can be done but don't know how to get there. I have an excel sheet with 8 columns a-h. This is spreadsheet to keep record of quotes given through the year, a new one starts every year. Columns are: Dates, Quote #, Project name, Preparer's name, Value, Status, Engineered by, and lastly who it was sent to. (those are in order, A-H respectively). Currently the spreadsheet is sorted by colum B as a new Quote # is taken for each project. Quotes are usually in one row unless it is sent to more than one bidder. In that case, the next row is used ONLY in the H column leaving the 7 others to the left blank. Also between quotes is 1 blank row just to make the thing look neater.

Now here's what i'm trying to do. I want to be able to have a list sorted first by bidder, then by status, then by job name, then by quote number. I only want to show the bidder for the first job that they have. I also want to have this on the second sheet of the file.

I know this is probably ridiculously advanced for me. I'm easily an advanced computer user, just am not so advanced with excel. Any help would be GREAT.