Pull info from one excel file to another depending on values of O.

C

Cooldistribution

I need the formula that can transfer rows based on a > value of a cell in a
row into a different excel file. For example:

Part# Jan Mar Oct Total Avg 1st QtrAvg 2nd QtrAvg 3rd QtrAvg 4th
Qtr Avg
913 3 1 1 5 1.6 1.3 0.00
0.00 .33


I want to be able to pull the rows whose values are > 1.0 for a Qtr avg. or
a given qty into a separate file perpetually.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help 1
Sorting CSV Data By Date 8
Still trying to average 4 worksheets and having formula problems 3
Excel VBA - macro that copies the sheets to another workbook 3
Match Multiple Criteria and Return values positioned above the zero 6
Averaging cells in separate workbooks to make year-to-date average 7
Excel formula help needed 2
import data from txt file to an existing excel file 1

Top