I have created a very basic userform for entering data into my excel document, the document will be used to track figures from two buildings. I want to be able to input any data I have in my form and then when I click Ok it sends that data on the left to the sheet for Building 1 and the data on the right to the sheet for Building two. A bonus would be a pop-up form allowing me to select either building and this then bringing up a secondary userform with the relevant data to input. The data for these two buildings will be different and it will need different details so I cannot combine and send to both at the same time.

I want the form to open up as soon as the excel document is opened, with a close form button for if there is no data to input. I would also like it to be possible to leave some spaces blank and this not cause an issue for submitting the form.

I have tried to create it so I could hit a New Entry button to bring up this form but I am very new to macros so am struggling. I have not been able to get anything remotely close to working, and have realised that my VBA knowledge is next to none.