| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
See this page then DD
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" <(E-Mail Removed)> wrote in message news  9712D9F-4281-4391-8108-(E-Mail Removed)...>I have a about 250 rows. I want to select and grab the rows that all have the > same value in column B and copy and paste them into their own spread sheet > for each change in column B. > > > "Ron de Bruin" wrote: > >> Selecting is not needed in 99% of the cases >> >> What do you want to do ? >> >> >> -- >> >> Regards Ron de Bruin >> http://www.rondebruin.nl/tips.htm >> >> >> "DD" <(E-Mail Removed)> wrote in message news:FCEEA277-DF0D-4915-B071-(E-Mail Removed)... >> > After I autofilter how do I select the filtered rows? >> > Selection.AutoFilter >> > Selection.AutoFilter Field:=2, Criteria1:=B2 >> > >> > >> > "Ron de Bruin" wrote: >> > >> >> Hi DD >> >> >> >> > Is there a Method opposite of ColumnDifferences >> >> No, Use a AutoFilter for that >> >> >> >> -- >> >> >> >> Regards Ron de Bruin >> >> http://www.rondebruin.nl/tips.htm >> >> >> >> >> >> "DD" <(E-Mail Removed)> wrote in message news:993800B6-C5EA-4F0B-9513-(E-Mail Removed)... >> >> > Is there a Method opposite of ColumnDifferences? I looking to select all the >> >> > cells within a column that are the same. >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thanks Ron
 "Ron de Bruin" wrote: > See this page then DD > http://www.rondebruin.nl/copy5.htm > > -- > > Regards Ron de Bruin > http://www.rondebruin.nl/tips.htm > > > "DD" <(E-Mail Removed)> wrote in message news 9712D9F-4281-4391-8108-(E-Mail Removed)...> >I have a about 250 rows. I want to select and grab the rows that all have the > > same value in column B and copy and paste them into their own spread sheet > > for each change in column B. > > > > > > "Ron de Bruin" wrote: > > > >> Selecting is not needed in 99% of the cases > >> > >> What do you want to do ? > >> > >> > >> -- > >> > >> Regards Ron de Bruin > >> http://www.rondebruin.nl/tips.htm > >> > >> > >> "DD" <(E-Mail Removed)> wrote in message news:FCEEA277-DF0D-4915-B071-(E-Mail Removed)... > >> > After I autofilter how do I select the filtered rows? > >> > Selection.AutoFilter > >> > Selection.AutoFilter Field:=2, Criteria1:=B2 > >> > > >> > > >> > "Ron de Bruin" wrote: > >> > > >> >> Hi DD > >> >> > >> >> > Is there a Method opposite of ColumnDifferences > >> >> No, Use a AutoFilter for that > >> >> > >> >> -- > >> >> > >> >> Regards Ron de Bruin > >> >> http://www.rondebruin.nl/tips.htm > >> >> > >> >> > >> >> "DD" <(E-Mail Removed)> wrote in message news:993800B6-C5EA-4F0B-9513-(E-Mail Removed)... > >> >> > Is there a Method opposite of ColumnDifferences? I looking to select all the > >> >> > cells within a column that are the same. > >> >> > >> > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| time differences in a column | =?Utf-8?B?NjhtYWdub2xpYTcx?= | Microsoft Excel Worksheet Functions | 3 | 9th May 2005 09:46 PM |
| time differences in a column | =?Utf-8?B?NjhtYWdub2xpYTcx?= | Microsoft Excel Worksheet Functions | 7 | 31st Mar 2005 06:19 PM |
| Column heading differences | =?Utf-8?B?YnJld2Rvbg==?= | Microsoft Excel Misc | 1 | 29th Dec 2004 04:20 PM |
| Hilight differences in column??????? | =?Utf-8?B?bWFseWNvbQ==?= | Microsoft Excel Misc | 1 | 13th Jul 2004 12:59 PM |
| Help identify column differences | Malcolm | Microsoft Excel Misc | 2 | 4th Sep 2003 04:59 PM |
