Copy data from column that begins with data to new sheet

[Snapdaddy]

Hello,

I'm currently trying to copy data from a row in excel based on what's
in colum B to it's own sheet. I've found some good macros but need some
help on how to modify it to fit my needs.

The one macro that is almost perfect is AdvFilterRepFiltered.zip on
http://www.contextures.com/excelfiles.html#CondFormat

That being said,

Column B consists of something like this:
3960020262
3960020263
4550050473
4550050474

I want to be able to sort 39600 and 45500 to their own sheet. The macro
I mentioned above works great but it will sort everything to it's own
sheet that doesnt match exactly. I need it to only look the first 5
numbers and copy the rows with matching numbers into a new sheet. If
anyone can shed some light on this it would be much appreciated.

Thanks
Jeremiah

[Dave Peterson]

How about adding another column, then extract the first 5 digits of that value.

=left(B2,5)
(if they're always 10 characters)

or
=left(text(b2,rept("0",10)),5)

or something????

Then use that column to extract the data.

Snapdaddy wrote:
>
> Hello,
>
> I'm currently trying to copy data from a row in excel based on what's
> in colum B to it's own sheet. I've found some good macros but need some
> help on how to modify it to fit my needs.
>
> The one macro that is almost perfect is AdvFilterRepFiltered.zip on
> http://www.contextures.com/excelfiles.html#CondFormat
>
> That being said,
>
> Column B consists of something like this:
> 3960020262
> 3960020263
> 4550050473
> 4550050474
>
> I want to be able to sort 39600 and 45500 to their own sheet. The macro
> I mentioned above works great but it will sort everything to it's own
> sheet that doesnt match exactly. I need it to only look the first 5
> numbers and copy the rows with matching numbers into a new sheet. If
> anyone can shed some light on this it would be much appreciated.
>
> Thanks
> Jeremiah

--

Dave Peterson