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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL: Find data in worksheet and create a new sheet in same workb
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL: Find data in worksheet and create a new sheet in same workb
Ok the following is exactly as you see it in the worksheet:
Architecture & Urban Design Book # Qty Title/Yr ISBN 21269 Francis 0774801786 23057 As You Pass By: 1995 0874804892 Art & Graphic Design Book # Qty Title/Yr ISBN 13140 Will Shuster: 1989 0890131996 18560 Claude Lorrain 1984 0295974419 24272 Yemeni Pottery. 1994 0714125121 AND SO ON...... Thank you, *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL: Find data in worksheet and create a new sheet in same workb
Ok the following is exactly as you see it in the worksheet:
Architecture & Urban Design Book # Qty Title/Yr ISBN 21269 Francis 0774801786 23057 As You Pass By: 1995 0874804892 Art & Graphic Design Book # Qty Title/Yr ISBN 13140 Will Shuster: 1989 0890131996 18560 Claude Lorrain 1984 0295974419 24272 Yemeni Pottery. 1994 0714125121 AND SO ON...... Thank you, *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
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 |