Try looking here at Ron de Bruin's site:

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


"Shandy720" <Shandy720.1tnk2m_1123851975.3508@excelforum-nospam.com> wrote
in message news:Shandy720.1tnk2m_1123851975.3508@excelforum-nospam.com...
>
> I have a sheet of data in five columns which i need to organise into
> different worksheets. So i need a macro to check all cellvalues in
> ColumnA (which range from 9-20) and copy the entire row into a separate
> worksheet for each value.
> In the ned i want a worksheet with all the rows which have '9' in
> ColumnA, a worksheet which has all the rows with '10' in ColumnA and so
> on.
>
> Any help would be great, thanks a lot,
> Andrew
>
>
> --
> Shandy720
> ------------------------------------------------------------------------
> Shandy720's Profile:
http://www.excelforum.com/member.php...o&userid=26230
> View this thread: http://www.excelforum.com/showthread...hreadid=395266
>