ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pull info from one excel file to another depending on values of O. (https://www.excelbanter.com/excel-worksheet-functions/262664-pull-info-one-excel-file-another-depending-values-o.html)

Cooldistribution

Pull info from one excel file to another depending on values of O.
 
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.


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com