| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple workbooks in one file
I am trying to create a database of textbooks in our inventory. I was hoping
someone who is more savvy than I could tell me how to do it. I want to use Excel 2007 (but I could use Access 2007 if it would only work there) and I need one all-encompassing inventory. I would like to be able to open one file and get 7 workbooks each with multiple worksheets for separate data. i.e. Textbooks (all-encompassing file) -Science (workbook 1) -Biology, Chemistry, etc (10 worksheets) -Math (workbook 2) -Trigonometry, Calculus, etc (3 worksheets) -English (workbook 3) -1010 (1 worksheet) -Practical Sciences (workbook 4) -Electrical, Aviation, etc (9 worksheets) -Social Sciences (workbook 5) -History, Psychology, etc (9 worksheets) -Arts/Humanities (workbook 6) -Art, Humanities, etc (4 worksheets) -Clickers (workbook 7) -TPT (1 worksheet) Does this make sense? Is it possible to get multiple workbooks saved as one thing all together like this? I would really appreciate any help at all. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Threaded Mode
