Hi,

Im trying to send data to different tabs. I have sorted the data in column C
so the numbers run one after the other. Is there a quick way of sending the
row of information to a tab after each different number in column C?

Thanks

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Or:

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

Kirk wrote:

Hi,

Im trying to send data to different tabs. I have sorted the data in column C
so the numbers run one after the other. Is there a quick way of sending the
row of information to a tab after each different number in column C?

Thanks

--

Dave Peterson

Kirk
If you wish, send me your file or a sample of it. Fake the data if you
wish. I need just the layout. Provide a clear example of what you want
moved where. Include a copy of this message and your post. Also the
version of Excel you are using. My email is .
Remove the "extra" from this address. Otto

"Kirk" wrote in message
...
Hi,

Im trying to send data to different tabs. I have sorted the data in column
C
so the numbers run one after the other. Is there a quick way of sending
the
row of information to a tab after each different number in column C?

Thanks