Thread: Copying Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KCWCD190 KCWCD190 is offline
external usenet poster
 
Posts: 2
Default Copying Data

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