Populating Cell Range Based on Data from Two Different Columns

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

Hi Robert!

Thank you for the prompt response to the issue... your solution worked perfectly! I was working on something similar but your code is much more functional than what I had so far... your solution is simple, elegant and best of all, it works really well.

Could I trouble you for an explanation on the use of the * character in the "lngLastRow =" line?

Thanks again for the help!!

Julian

Thanks again for the help Robert... you saved me from a lot of headaches on this one!

Julian