EXCELL Conditional formatging
I have a spreadsheet that I download from our turnstyle in/out system. I use conditional formatting to see who leaves early (before 5:20, before 4:00 and before 2:00) we are building a power plant and we have 2 sites side by side so several employees go back and forth... I ONLY NEED HIGHLIGHTED THE LAST CLOCK OUT FOR EACH EMPLOYEE and not every time they punched the clock out in a days time.... Can you please assist me... @links to members
User Access in excel sheets with macro's
Hi, I am seeking a way to prevent writing on a sheet at the user level without using a protect password method, since we use macro's to transfer data from one sheet to another even its protected. When attempting to transfer data from one sheet to another after protecting the sheet, an error 400 is generated. Could you please provide us the way to solve this. Thanks