Hi there,

First i admit i am very new to VBA, so please bear with me :)

I currently have a workbook setup where by people use a Input form to enter
details. The data in the form is the added to a hidden worksheet. Now the
workbook is getting exceedingly large and takes it time to open, close and to
save.

What i would like to do is have the Input form in one workbook and the data
to be sent to a serperate Data wookbook (and worksheet). Can this be done?

Or would i be able to setup a system via VBA that moves the data from the
Input workbook to a Data workbook and then clears the data it moves from the
Input workbook? (am i getting too complex here?)

Thanks,