macro assistance to automate text entry in selected row if another range has text

[lilsnoop]

Hello,

Looking for some additional assistance on a schedule project I've been working on, that would eliminate the manual process of selecting "DO" which represents "day off" for employees who have weekends off via a data validation process. Ideally I would like to select the row for the employee who would have weekends off and the macro would look at a range between c3 and ag3 for any cells that have "Sat" or Sun" in it and then based on that criteria the row that was selected would put the "DO" in the selected row, but in the column where "Sat" and "Sun" are listed in row 3. This would be a huge time saver. Any help would be greatly appreciated!

[:) Sixthsense :)]

Right click the sheet tab and select view code and add the below code

Please Login or Register  to view this content.

[sbehera]

TRY THIS....

Please Login or Register  to view this content.

[lilsnoop]

Hello sixthsense. Thanks so much for looking into a solution to my problem. I tried your code and it didn't work for me. I'm not sure if it is conflicting with some other coding I have going on, which is in my sample above too. As every employee won't have weekends off it will be important for me to select which employees (individually) I want to have the "DO" in the weekend cells. Thanks again!

[:) Sixthsense :)]

The code will run automatically when there is any change in C3 to Ag3 cells. Just try inputting Sat Or Sun in any of that range and see it will perform the task.

Yes, I seen your another code for highlighting the current row / column but that one is SHEET SELECTION CHANGE EVENT and I have given you SHEET CHANGE EVENT so there won't be any conflict

[lilsnoop]

Thanks sbehera! Your macro worked great for one selection and then I couldn't get it to work again for another row selection immediately afterwards.

sixthsense-I'll give it another try!

[lilsnoop]

sixthsense-I like what you've done, but it unfortunately puts the DO in every row for all employees and I would have to clear those fields for those employees that don't have weekends off. Any other idea?

[:) Sixthsense :)]

Ok... to which employee (Row) i have to fix it for???

[sbehera]

may be this will do......sory was in hurry to post. so didn't do the test properly......

Please Login or Register  to view this content.

[lilsnoop]

Excellent! Thanks!