Strange sorting question

[science]

Hello everyone,

I just discovered this site- what a wonderful place!

I have a database with over 10,000 text entries and I was hoping to come up with a way to sort them. Here is what I am trying to do: If a cell contains a certain expression, I want to be able to send it to a certain tab. For example, I want to write an "if-then" that basically says "if a cell contains 'apple', send to the 'foods' tab". Is this even possible in Excel?

Thank you all so much.

 

[Hui]

Science

Firstly, welcome to the Chandoo.org Forums

You have two methods to tackle this:

Firstly, Excel Doesn't push data, it pulls data
So your destination sheets can have formulas that pull the data from the source sheet
You could use a technique like that described by Luke at:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

or

Secondly you could use some VBA to move the data
refer: http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/

 

[science]

Hi Hui,

My apologies for the extremely late response. Thank you so much for your help! I look forward to learning a lot more through this site.