ok but it is a good solution and not too hard to learn

otherwise you need visual basic. that makes the spreadsheet more
complicated that using a pivot table

--
Allllen


"pgarcia" wrote:

I don't belive my user would know how to us a povottable. Please read reply
to JNW today.

Thanks

"Allllen" wrote:

a different idea:

use pivot table. create a povottable how you want. put the person's name
selection in the page field. copy the pivto table to 5 tabs. select a
different name in each tab.

--
Allllen


"JNW" wrote:

I guess what I am saying is, there is no need to create the five sheets to
separate data. Filtering allows you to sort and view how you would like in
order to analyze data then it can be put back. It is generally an easier
solution, it uses up less space, and it is harder to mess up.

I may be misunderstanding what you are looking for, but when you start
replicating data it makes things hard.
--
JNW


"pgarcia" wrote:

Will, I was hoping not to do a paste and copy. I just want to drop my data in
one tab and it will update the other 5.

"JNW" wrote:

I would just use filtering (DATA FILTER AUTO FILTER).
--
JNW


"pgarcia" wrote:

Hello again (world),
I have list that I need to return a value in a different spread sheet.
A2 is the person I need to locate and then return the data/valued in cells
B2, C2, D2 ect. (list is a lot longer and with other names). The spread sheet
will have 5 tabs with 5 different names. I want to do some kind of VLookup or
other function to run down the list and retune in sequential order. Any
thoughts?


Respoble GL Date Payment Method Batch Name
Betsy 4-Oct-07 900 Credit Card 2MLCLSAMEX100107
Betsy 4-Oct-07 900 Credit Card 1MLCLSAMEX100107
Betsy 3-Oct-07 900 Credit Card 1MLCLSPTCH100107
Betsy 2-Oct-07 900 Credit Card 1MLCLSPTCH092607A
David 4-Oct-07 031 Check 2MLCLSAMEX100108
David 4-Oct-07 032 Check 1MLCLSAMEX100127
David 3-Oct-07 031 Check 1MLCLSPTCH100807
Davd 2-Oct-07 033 Check 1MLCLSPTCH092625