If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|