worksheetssheet1.cellsi

Hi, I wrote the following code to loop through data column for keywords such as "personal" or "fraud" and copy rows with these keywords to a separate tab. The problem is that my code does not work when the keyword is within the phrase (i.e. "personal expenses"). Is there quick fix for that...

Hi I have created a userform in excel, where you can look a specific ID number up and through that update the specific information connected to the number. My problem is that I can't figure out how to get my checkboxes to update the value in the specific row with it being marked with an X or...

Hello, I have a VLOOKUP macro using the below VBA code. The idea is to take a list of UserID's (on Sheet1/Column A), and populate information for each user (Name, Job Title, etc.) based on a fairly large table array on Sheet2 of the Workbook. My question is, can this be modified in such a way...

Hi. I am managing a datasheet in which subjects have taken a survey (only those under age 17). I wrote a script to fill the remaining blank cells (w/out data) with the value 999 if the participant either is not included in study (column 3 cell value = 0) or if their age is >= 18. The script runs...