Link multiple workbooks by combobox.
Posted on 2003-03-22
This is going to be a multiple question that hopefully can be summed up with one answer.
Here is my situation.
I've created a workbook in Excel with 200+ worksheets that are all easily navigated by comboboxes that activate only the desired pages. My computer has now decided to run into memory problems while running this program.
1. What I would like to do, is split these worksheets into multiple workbooks, so the memory won't be a problem. But still keep the easily navigated program part. Is there a way to pull up sheets from a different workbook off of a combo box? And still be working in the "home" workbook not in 2 separate ones?
2. Also, is there a way to create a form that another person can fill out that would automaticly update other sheets... i.e. if a new product were to be added, a "New Product" form that would take data and place it in the correct spot on the "home" workbook.
3. Lastly, this would solve the problem right away. Is there a way to take a sheet that is only 10 columns by 100 rows long and only use that space and not the other million cells that are just using memory?
Thank you for all your help!