Hello everyone,
I need your help resolving this particular problem: I need to change the data in a range of cells in a column without changing the rest of the cells in that same column. Please take a look at the attached sample file.
I use a form to help the user input the data on the spreadsheet; the supervisor would look at the sheet at the end of the day and approved it if no problems were found... I have another userform to help with that as well. This userform takes a look at column A (range A6:A250) for a date and places the supervisor's name on column G (range G6:G250) if the data is present. At least that's the way it worked before... now the supervisors must look at the sheet at different times during the day and check it for errors... if none are found, then they need to sign off on it, along with a time stamp for that inspection. A few hours later another supervisor may take a look at the data and sign off on the work done up to his inspection... but the previous check must remain intact.
So, the problem is this: how can I populate a specific range in Column G without changing other parts in the same column? The userform must search for a date stamp on column A, then place the supervisor's name in column G without changing the name above the next empty cell in column G... based on whether or not there's a date in that same row located in column A.
On the sample sheet, you can see that supervisor Pink Panther approved the work done up to his inspection... what modifications to the code can I make so that the next supervisor can approve the other work without changing Pink's approvals?
Any help resolving this problem will be greatly appreciated!!
Thanks in advance...
Julian
Bookmarks