Need help with a formula and not sure if its even possible

[ceyoung75]

I have one sheet called "data dump" and one sheet called "pulls" in the "data dump" sheet i have three columns. One has a name, one has quantity, and one has price. I am trying to find a way to take the rows from data dump to pulls based on a keyword. AKA: If column A has word Corrupted in it then pull that complete row over to pulls sheet. But the main part is that it deletes the data from Data Dump when it moves it over.

 

[Rick Rothstein]

What "deletes the data from Data Dump"? Is this a VBA question? If so, would a formula solution be acceptable? The more details you can give us, the less guessing we will have to do.

 

[ceyoung75]

This is what the data looks like in the Data Dump Sheet. What i am trying to do is take a keyword, let's use Abyss as the keyword. It would find everything labeled Abyss and take the information from column B, C, And D and move it over to the new sheet i have setup called Pulls. When it moves that data over then line 1 through 9 would be deleted from the Data Dump Sheet and only show up on the Pulls sheet.. Does that make better sense. And i am hoping that it could be done by a formula and not a vb script

 

[Rick Rothstein]

Your data dump is text, so a formula cannot delete anything from it... and you would not want it to since the formula that pulls the data would be dependent on the data dump being in place (if you deleted the found data from the data dump, the formula pulling that found data would no longer have the data to pull any more). VBA code can do copying and deleting, but formulas cannot. So, I am not exactly sure how you want to proceed.

 

[ceyoung75]

Thanks I am gonna need to reevaluate this idea and come up with another idea. Thank you