Can anyone advise how to do the following, I have attached the word doc relating to this.
Tabbing through the work sheet to the Person(s) drop down box. What I want is if I select 1 Person the 2nd Person box disappears & everything carries on as is.
However if I select the 2 persons option, then the 2nd Person box appears. That is my first requests?
Secondly. Once the 2nd Person box appears I want it so that the hrs that are filled in towards the bottom of the sheet are split in two between the 1 Person & 2nd Person job, so if 6 hrs are entered then 3 hrs will appear in both 1st & 2nd Person boxes.
Lastly the boxes that all have 0 hrs, I cannot enter any 0.25, 0.5, 0.75 ie 1/2 or 3/4 hr entries, it defaults to 0?
I'd appreciate anyone who can help me with this, my programming / macro skills are zilcho. Thanks in advance.
Last edited by simonwilliams; 03-07-2011 at 05:32 AM.
There's no attachment
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Ooops, thanks for pointing out, attachment is now attached!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks