I have a spreadsheet that is a customer database. Each customer is charged
according to a specific category (Category 1, 2 and so forth) I need to
create a separate worksheet for each category. Is there a formula that will
reference the main sheet and copy only those customers for a specific
category? I have tried the vlookup formula, but can't get that to work
correctly.

Any help I can get with this would be greatly appreciated.
--
KCWCD190

One play which gets you there ..

Try this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "State" col, which may
contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will
be auto-copied to the sheet named: NY, and appear neatly bunched at the top.
Ditto for lines with "CA", "NV", etc which will be copied into their
respective sheets.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the next key col value. Eg we
first formulate one child sheet for "NY", dress it up nicely, then just make
copies of the "NY" sheet, and rename these as: CA, NV, SD, etc.

In your case, the key col would be the category, eg: category 1, category 2,
etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KCWCD190" wrote:
I have a spreadsheet that is a customer database. Each customer is charged
according to a specific category (Category 1, 2 and so forth) I need to
create a separate worksheet for each category. Is there a formula that will
reference the main sheet and copy only those customers for a specific
category? I have tried the vlookup formula, but can't get that to work
correctly.

Any help I can get with this would be greatly appreciated.
--
KCWCD190

Let's say we have a row for each customer and column D is Catagory. Make
sure D1 is a label and not a piece of data. Select D1 and pull-down:

Data Filter AutoFilter

If you pull-down and select 1 for the catagory, then only the catagory 1
rows will be visible. Copy them and paste them in the other sheet.

The copy/paste will only pick up the visible rows
--
Gary''s Student
gsnu200710


"KCWCD190" wrote:

I have a spreadsheet that is a customer database. Each customer is charged
according to a specific category (Category 1, 2 and so forth) I need to
create a separate worksheet for each category. Is there a formula that will
reference the main sheet and copy only those customers for a specific
category? I have tried the vlookup formula, but can't get that to work
correctly.

Any help I can get with this would be greatly appreciated.
--
KCWCD190