Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL: Find data in worksheet and create a new sheet in same workbook
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create copy of sheet tab (excel 2007) when opening workbook | Excel Worksheet Functions | |||
How can I find/unhide hidden excel sheet tabs on a worksheet? | Excel Worksheet Functions | |||
how to create a chart in excel with data from another workbook | Charts and Charting in Excel | |||
copy data from one worksheet to identical sheet in different workbook | Excel Discussion (Misc queries) | |||
How to find the type of Sheet in Excel.Workbook.sheets collection | Excel Programming |