I make reports out of the same excel sheet (which was not built by me). Part of the information for the report comes from an operator of an actual machine. There is a bit of manual calculation and input that is done from the info they provide. I want to have them fill an external user form (that looks as little like an excel sheet as possible) that can then be loaded to the master sheet. Then I can automate the calculation and report making. I have been searching and cannot find a good way to do this. All the user forms are inside excel master sheet itself which doesn’t help.
Thank you for any help. If you need more info, please ask.