Not too sure which application I should be doing this in........
I've attached a form that I'd like to fill via a user form (or similar). I have fiddled with it a bit and found the user form a bit cumbersome due to space restrictions (I don't want the user to scroll down the user form, rather it take up the entire screen). I did debate whether, if possible, to have more than one user form relating to each area of the form and for the user to link to this through the first user form. Or to do it in Access which would simplify things.................but can I then transport the data to the excel sheet?
Basically there are certain fields where the user can select data, and other fields are automatically filled dependant on the data selected.
I have a feeling I'll be doing it Access, but how do I go about transporting the data to the attached sheet?