review

I have tried to block just a few cells with formulas in a sheet leaving free the rest of the cells to be filled by variables if needed, I followed the Microsoft title "Lock or unlock specific areas of a protected worksheet" with NO success I wonder what I did wrong this is what I did: I...

Hello! I am creating an Access report. Inside the report, I have created a box that will count the number of project inspections (based on Review type column) given a date. It is worthy to note that a single project inspection on a given day can have multiple findings. I am not interested in...

Good morning everyone what I want to do is set up a review date 366 days after the date the file was started I do not want to worry about month and year only days as when the file is reviewed the 366 days will come back in effect. I can later on, when the file is 30 days from review date I can...

Say I have 4 quizzes, and there is an optional Review Session. Student gets either 100 or 0 for attending/not attending the review session. If student attends the review, their lowest quiz scores will be replaced by 100, provided the quiz to be replaced is at least 70. Please note that there...

Does CDO messaging not support reviewing emails? My client (a state hospital) must encrypt patient-related emails with Virtru. This is a setting on the message so I need to set the message to Review. Unfortunately that is not a CDO.message option! Can this be done? If not what other library can...

I am trying to write a macro in order to do the following: In one workbook, I want to search for data from another workbook and return a value based on the ID # if certain criteria is met. IE: If it says Melanie Jackson or Hector Hernandez in the October column, I want it to return this value...

I have a spreadsheet of employees. Through a userform, I enter various updates on performance, status, etc. Each update is entered on a new line. An employee might be assigned to different departments. What I'd like is some guidance on VBA that will retroactively update all prior...

I've been struggling with trying to have a msgbox that is prompting other msgbox's. and a yes equaling two separate msgbox's. if it were to look like a tree I would draw it to look like this: New Yes/No; ____no=endsub ____1yes= New XXX Yes/no; ________________no=XXX (sheet not visible)...

I am fairly new to coding in VBA and was wondering how to add an error formula to the following string of code: For I = a To lastRow If Range("I" & I).Value / Range("H" & I).Value > 1 Then Range("P" & I).Value = "Review" Range("Q" & I).Value = "Review" Range("R" &...

Hi all, Is it possible to conduct the following checks in the order listed? 1. Is the first character a number or letter, if it's a letter, is it capitalised? If it's not capitalised, it needs review. 2. Is any character after any space capitalised and the following character not capitalised...

Hello Excel Masters The below formula works perfectly and returns either a blank cell or a date =IF(ISNA(INDEX(RawCu!K:K,MATCH(1,("54-Complete-Billing Review"=RawCu!E:E)*(C5=RawCu!B:B),0))),"",INDEX(RawCu!K:K,MATCH(1,("54-Complete-Billing Review"=RawCu!E:E)*(C5=RawCu!B:B),0))) The above...

Good Day!! I am a little lost, and hoping someone can at least point me in the right direction. Every month, I need to review 20 hotels on TripAdvisor.com and see what their rankings are. One example here for Hilton Cleveland is #3 of 38 (as of right now, may change at some point). Here is...

Hey Guys quick one (hopefully ;)). I have a cell that contains multiple text entries. I would like to find dates within that cell. I've partially solved it however I can only find the first date. For example: currently the formula I have finds the first date by search for the word review...

I need a formula that will give me the minimum date after today, and it needs to ignore blank cells. Employee reviews are conducted after the employee is employed. In ROW 3, lets day the employee starts today, and will be away in training for the month of June. How do I skip the blanks spaces...

I need help changing the below formula to add "Discussion Needed", if the date is the 22 Month Final Review Due has passed. =MIN(IF(Table1[@[6 Month Review Due]:[22 Month Final Review Due]]>TODAY(),Table1[@[6 Month Review Due]:[22 Month Final Review Due]])) Thanks in advance.

Hello All, I have a IF formula that is not working saying "too many arguments" however I tried to follow the details HERE: https://exceljet.net/excel-functions/excel-if-function =IF(Y2=88,"Complete","Under Review",IF(X2=88,"Not Started")) Can anyone help.

Hello- I am completely new to Excel and to this website. I have tried to use other forums and post my questions but unfortunately, I do not get any replies. So I am hoping you can help. I have a spreadsheet that I created in Google Sheets. My end goal is to upload the sheet to my work...

I don't know if I need to use VLOOKUP, INDEX, MATCH or a combination of them. I need to get the employees review dates from Sheet 2 into Sheet 1. The dates on Sheet 2 are in a row, and I need them on Sheet 2 in a column, but I need them in the correct month. So using Sheet 1 A3 as an example...

I have the following formula in a cell: =MIN(IF(Table1[@[6 Month Review Due]:[22 Month Final Review Due]]>TODAY(),Table1[@[6 Month Review Due]:[22 Month Final Review Due]])) I would like to have "Recommendation Needed" to show in the cell if the date in 22 Month Final Review Due cell has...

Hi I have a cell A1 that contains a date 1/1/2018 in A2 I have a review period taken from a drop down list contained in N5:N17. In M5:M17 I have the number of days that the review periods correspond to. What I need to do is in A3 is to calculate the review date by taking the selected drop down...