ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Export sheet store sheet import sheet. (https://www.excelbanter.com/excel-programming/380165-export-sheet-store-sheet-import-sheet.html)

Robert[_33_]

Export sheet store sheet import sheet.
 
I am working on an excel database. I have an excel file where I make a
sheet including a question for students. At another sheet I calculate
all possible answers. The problem when I create a lot of questions the
workbook gets to large and very slow.

what I want to make is a system where I export the sheet including the
question and the sheet holding all answers. All of this sheets become
one database. From the original sheet I can summon the database and
select the questionsheets (& answers). Once selected I want to insert
them in the original file. The first step I need to take is to export
an entire sheet en import it later via a selection window.

Is there anyone who has experience with this kind of exchange between 2
workbooks? Any help would be great considering I have not much
knowledge of VBA.



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com