Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pulling info into another sheet
Hello,
I have a work sheet that looks like this: 19080 MISC, CT PUMP, 9V 2 D3B Count 19091 DP-270 EPOXY 35 d3c 59009 MISC, CMDR BASE 3 D1D I have another worksheet that I am trying to automate. I need to be able to pull out the rows that have count in the first column. I only want the ones that say count to show up. When I do an if statement or something like that. It will pull those rows but then it also pulls all of the other rows and leaves blank spaces. Does anyone know how to only get the count ones over to the new sheet? Thanks. Teri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/Contents Sheet | Excel Discussion (Misc queries) | |||
Pulling Row and Column labels from other cells. | Excel Discussion (Misc queries) | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions |