that looks like it will work!! do i need to do this 50 times for each box or can i do one and carry down? also is there a video or website that you can suggest i reference? lastly....... was that conditional formatting that turned the "Name" cell yellow when the correct client name was selected? IF i do get stuck and need further paid help can you "recommend" someone?
Thanks and Merry Christmas
im not sure of the which method is better for what i'm trying to achieve. I am a decent excel person and have tried to solve by scouring youtube for answers. I have no idea how to do VBA i just started trying to learn macros to speed up things like password protecting/unprotecting my sheets and other small novice features. this one i am unable to fix and it has become frustrating
newest one, where i added columns off to the right to try to verify pay rates of known trucks to reduce payroll errors
on #2 i was trying to set up the autocomplete by typing feature for the "Truck Owner" section down in the middle. I was able to set it up and get it to work by turning off the data validation > "error alert" tab. My problem is that when i released it to the field the guys were able to start typing in the dropdown box to quickly find the truck owner, but then wouldnt select, or tabbed out of the cell early causing me to have to go in and fix multiple cells (13-20 timesheets a day.) because the VLOOKUP feature wouldnt pull the "Minority Trk & Truck ID" information to the left that is needed for payroll
i am trying to find a way to let them type in the "Truck Owner" field quickly narrow down the list, but also have some type of data validation that will force them to chose only from the list. Any help you could offer would be much appreciated
i'm new to this as you can tell. i have tried/searched numerous ways to create a searchable dropdown list with no luck and 123% pure frustration. i currently have a spreadsheet with 30 or so Data Validation boxes all pulling info from a single column on a different sheet (basically a timesheet where the foreman selects his hourly trucks). It does work, but i have a lot of complaints in the field because the "Truck Owner" field is not searchable. can anyone please help me? thanks in advance. i can send a copy of the sheet