In excel how do i extract my total customer details to 8 individu.

[Guest]

I am trying to write a spreadsheet which list 8 customers in a total sheet.
Also it has to show each customer seperate on a individual sheets with all
their details
Is there a equation or lookup option i can use to achieve this??

 

[David Burr]

You don't give a lot of detail but I can imagine a
solution whereby you use one worksheet to enter all your
data in a nice plain table.

Then create a Pivot Table on the data entry sheet that
includes the columns or agregation you want to see. You
can have a page filter on the Pivot Table so that you
choose the client you want to show and from a dropdown.
You can just switch from client to client using the
dropdown which is much better than having a separate
worksheet for each client. You really don't want to have
to maintain lots of identical worksheets.

 

[Gary Thomson]

Type the name of a customer in cell A1 of sheet2!.

Then in cell A3, type this formula:

=vlookup(A1,Sheet1!$A$1:$Z$100,column(A$1)-column($A$1)
+1,FALSE)

then copy across for as many columns as you need.

This assumes the following:

in Sheet1! (where your data is held presumably), the data
is held in the array $A$1:$Z$100 (if not, simply change
the reference in the formula