Filter the original sheet based on comparison and paste the results onto a new sheet

Dear Forum Gurus:

Please take a look of the following description and provide a code to do described tasks.


Pseudo Code:
1, Create a new sheet called "Short List" on the next available tab

2, Add headers to the sheet "Short List" : Part #, Part Description, Total Quoted Value, Annually Average Quoted Value, Average Quoted Price Per Item, Lost/Demand, Annually Average # of Inquires

3, Starting from row 2 of sheet "Quote Summary",
if the value of D2>5000 & the value of F2>20 & the value of K2>0.3 & the value of L2>3
then copy the values of cells A2, B2,C2,D2,F2,K2,L2 from sheet "Quote Summary" and paste them to the next available row in the same order onto to the sheet "Short List" .

4, Repeat step 3 for all of the rows of the sheet Quote Summary


Process Sample-Create Short List Based on Filtering Results.xlsm


Thank you and I am looking forward to your response,

Chris

Originally Posted by PCI

The test don't select any data ( Column never > 5000) but try next code with new data

Please Login or Register  to view this content.

Dear PCI:

Thank you so much for your response!

The code did a great job to process my 50k rows of data!

Thanks again,

Chris