I'm trying to figure out a way for a User to select the names of workers that are in the office, then have VBA place those names in cells based on the value of another cell.
I would like for the User to click a button on a form, that launches another form (let's call it frm_Reviewer_Assignment). Within this form, there's either a drop down box or radial buttons (I'm not sure which would work better) with the names. The User selects the names of people that are in the office that day, then Excel enters the selected names into column BW, where the value of column CD = "Pending Initial Review". *Column BW may, or may not be null at this point. If it isn't null, then I would want to overwrite the current entry.
Scenario 1:
790 total records.
90 records have a value of "Pending Initial Review" in column CD.
3 Names are selected (Bob, Mary, Tom).
Bob, Mary and Tom have their name entered on 30 records each.
Scenario 2:
790 total records.
90 records have a value of "Pending Initial Review" in column CD.
4 Names are selected (Bob, Mary, Steve, Tom).
Bob and Mary have their names entered on 23 records each, while Steve and Tom have their name entered on 22 records each.
If I were doing this without VBA, I'd just filter column CW to the values I want, then type the names into the first couple of cells, then use the auto-fill box. I haven't the foggiest idea on how to approach this using VBA though.
I posted a similar question on this about 6 weeks ago, but didn't receive any replies, and the file structure has changed, so I tried to describe the ask a little better in hopes that someone can provide some guidance.
I would like for the User to click a button on a form, that launches another form (let's call it frm_Reviewer_Assignment). Within this form, there's either a drop down box or radial buttons (I'm not sure which would work better) with the names. The User selects the names of people that are in the office that day, then Excel enters the selected names into column BW, where the value of column CD = "Pending Initial Review". *Column BW may, or may not be null at this point. If it isn't null, then I would want to overwrite the current entry.
Scenario 1:
790 total records.
90 records have a value of "Pending Initial Review" in column CD.
3 Names are selected (Bob, Mary, Tom).
Bob, Mary and Tom have their name entered on 30 records each.
Scenario 2:
790 total records.
90 records have a value of "Pending Initial Review" in column CD.
4 Names are selected (Bob, Mary, Steve, Tom).
Bob and Mary have their names entered on 23 records each, while Steve and Tom have their name entered on 22 records each.
If I were doing this without VBA, I'd just filter column CW to the values I want, then type the names into the first couple of cells, then use the auto-fill box. I haven't the foggiest idea on how to approach this using VBA though.
I posted a similar question on this about 6 weeks ago, but didn't receive any replies, and the file structure has changed, so I tried to describe the ask a little better in hopes that someone can provide some guidance.
