Hi Peace,
Need a little more information. The category is not a "Field" in the sheet?
How does one know what category a book belong to with out that information?
Maybe the category is a "Header" above all books in that category?
David

"Peacce Dog" wrote:



Hello all this is my first time posting. I am working on an excelsheet
that has a list of stuff on it in the following format:


'Category - not an actual field on sheet

African-American Studies

'Information following - not an actual field on sheet
Book # Qty Title/Yr ISBN
15558 What Should Do 0345380452

ECT.........


Each category will vary as to how many records are under said category
each week.
The "MainWS" worksheet will have multiple categories on it with the
information in the format above.

What I want to do is have a query that will go through the "MainWS"
worksheet in the "MainWB" workbook and create a new worksheet in the
"MainWB" with all the records under each category.

Is this possible and if so could someone help me with this. I usualy do
all my record keeping in access however this must be done in excel. I am
Intermediate with VBA, but not good with excel.

THANK YOU IN ADVANCE !!!!
-Peace

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!