Second post ever, trying to follow rules. Please let me know if I am violating them. Thanks.
I am willing to share my document if someone feels they can help me, just not sure exactly how to on this forum.
I have a "Master" file that will be used by several people. It has several hidden sheets (in document, they are for different Rooms). I have it set up as follows:
-This document is an audit, with scores that are entered and averaged at the bottom of each worksheet (each room gets it own score).
-A userform has two text boxes, where users will input a room name and tab(worksheet) name. The hidden "Master" worksheet is then copied with the user input data copied to the newly created worksheet.
-I have an overall scorecard worksheet. The scorecard will have each room listed, and two equations per room.
What I need help with is imputing an equation into the scorecard, and modifying with it the worksheet name entered by my users via the userform textbox.
I think this is quite complicated, and I really can't figure it out. I would really appreciate someone that had patents with me and willing to teach me. Thank you for any help you can offer.
BTW, this is my first really excel project for work, so I bought VBA Programming for Excel for Dummies about 2 weeks ago, so I am only going on 2 weeks of experience.
Bookmarks