With Excel, I was able to create a group of 30 radio buttons that when one was selected, it would send a value to sheet2.$a$2, and then calculations on sheet 2 would use that number to calculate the rest of the sheet. The reason for the radio buttons are so that the user of the sheet can only select ONE of the radio buttons.
Secondly, the Command button on sheet 1, it's only function was to run a macro that printed sheet 2. Basically, the user never needed to even look at sheet 2, but sheet 2 is the output that was desired from all of the data on sheet 1.
I would greatly appreciate anyone's help on this.
Additional info:
There are 15 rows associated with data (basically 2 weeks of data. Each set of 2 weeks has one person associated with it. Their name is entered in a merged cell, and the Radio button basically sets a starting number into 'Group.B2' which is multiplied by 15 and then is processed by a cell grid of 26x14 cells that require this data to be copied from the data sheet to individual time sheets.
The long and short of it.... After all the data is entered into the 'DataSheet' then they select the person (via radio button) then click the print button and out come their time sheets for each person, which can then be put into a ring binder for later lookup.
Thanks in advance.
-SWarrior
Secondly, the Command button on sheet 1, it's only function was to run a macro that printed sheet 2. Basically, the user never needed to even look at sheet 2, but sheet 2 is the output that was desired from all of the data on sheet 1.
I would greatly appreciate anyone's help on this.
Additional info:
There are 15 rows associated with data (basically 2 weeks of data. Each set of 2 weeks has one person associated with it. Their name is entered in a merged cell, and the Radio button basically sets a starting number into 'Group.B2' which is multiplied by 15 and then is processed by a cell grid of 26x14 cells that require this data to be copied from the data sheet to individual time sheets.
The long and short of it.... After all the data is entered into the 'DataSheet' then they select the person (via radio button) then click the print button and out come their time sheets for each person, which can then be put into a ring binder for later lookup.
Thanks in advance.
-SWarrior