Want to Distribute Data from Sheet A to the other sheets based on Criteria

**jordan1214** · 04-12-2013, 08:37 PM

So, what I am trying to do is move/copy each row from the "database" sheet and distribute them to the other sheets (C,1B,2B,SS,3B,OF).

I will be copying and pasting data into "database", I would like to distribute them based on the matching data in Column B. (Column B data matches what sheet it will be sent to)

I'm not sure how to set up something so that I will be able to continually update the "Database" sheet and have it keep moving the rows to the appropriate sheet.

Thanks so much for the help in advance.

**jordan1214** · 04-12-2013, 08:41 PM

I added a second worksheet (Sample12) that includes data in the "Database" sheet in case that is needed in order to get this formula/macro working.

**FDibbins** · 04-12-2013, 08:45 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...-criteria.html

Thread Closed.