Hello All,
I need some help with something that has been bugging me for quite some time. If any of you girl/guys can give me some assistance it would be greatly appreciated.
I have an excel spreadsheet with a column that has multiple reviewer names (i.e Scott, Paul, George, Tom, etc...) all in different rows along the same column. I need the end user who is then QC'ing the excel spreadsheet for errors to be able to input their names next to the names with the multiple reviewers. Here is an example of what should happen:
Original Copy:
Scott
Tom
George
Tom
Final Copy:
Scott/Brandon
Tom/Brandon
George/Brandon
Tom/Brandon
This may be tricky enough, but I have something that is even more important than that... Since the QC'ing process is very tedious we have split the spreadsheet into sections. For example: Brandon is given rows 312-482. I need the end user (let's say Brandon) to be able to:
1. Upon opening the spreadsheet have a pop-up window open or when finishing have a pop-up window open
2. The pop-up window would ask the user to input their name and rows they have in their section
3. The user hits enter and my example above would be the end result.
I know I am asking a lot, but any help would be appreciated.
Regards,
B
Bookmarks