searching and moving text
 

Hello,

I have a spreadsheet text in column A with repeating names and I need to
display the data found in column B on another "page 2" in Excel. The problem
I'm having is that "page 2" needs to display the information for that person
only with no other data. Here is an example.

1 2
A Fred 5155551111
B Steve 8085552222
C Fred 7025555555
D Fred 9095554444

On "page 2", I want it to just include the Fred information only and on
"page 3" I want the Steve information only. I'm not very experienced and
would appreciate any help at all in moving the data. Thanks!

searching and moving text
 

I'd keep the data in one worksheet.

Then use data|filter|autofilter to see the info that I want. I think you'll
find that this is the easiest solution.

But if you really, really must. Keep the data in one worksheet and refresh the
worksheets whenever you need (not while doing input--just run the macro when
you're ready).

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

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Lost in Excel wrote:

Hello,

I have a spreadsheet text in column A with repeating names and I need to
display the data found in column B on another "page 2" in Excel. The problem
I'm having is that "page 2" needs to display the information for that person
only with no other data. Here is an example.

1 2
A Fred 5155551111
B Steve 8085552222
C Fred 7025555555
D Fred 9095554444

On "page 2", I want it to just include the Fred information only and on
"page 3" I want the Steve information only. I'm not very experienced and
would appreciate any help at all in moving the data. Thanks!

--

Dave Peterson

searching and moving text
 

I will assume that a "page" is a "worksheet".

See Ron de Bruin's site for VBA code that filters for Fred and and will copy
Fred's rows to a new worksheet.

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


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 08:07:01 -0800, Lost in Excel <Lost in
wrote:

Hello,

I have a spreadsheet text in column A with repeating names and I need to
display the data found in column B on another "page 2" in Excel. The problem
I'm having is that "page 2" needs to display the information for that person
only with no other data. Here is an example.

1 2
A Fred 5155551111
B Steve 8085552222
C Fred 7025555555
D Fred 9095554444

On "page 2", I want it to just include the Fred information only and on
"page 3" I want the Steve information only. I'm not very experienced and
would appreciate any help at all in moving the data. Thanks!