verification

I have this workbook that has columns A through E with information. For column A, I was looking for a VBA that will compare the current data in the cell (starts at A2) until the end of data, to see if it matches with data in ("Sheet2") range would be G2 until the end of data. This will go...

I need help filtering on multiple criteria. Consider the sample data below that provides a greatly simplified data set. I need to show all data for the current date and any data from previous dates with a status of "Complete Pending Verification. I am not sure if it will matter, this table...

I have a sheet in excel and i need it to guarantee that a range of cells have entered data before completing the macro. I can get it to verify one cell but not all the other cells i also need verified. Sub CommandButton1_Click() ActiveSheet.Unprotect Dim nom As String Dim path As String If...

Hello everyone, I am working on the tool which helps to verify/test spreadsheet models - http://exceltested.com The idea is inspired by unit testing from programming and many stories when Excel mistakes had serious consequences:European Spreadsheet Risks Interest Group - spreadsheet risk...

Hello, What I am trying to accomplish is the following, One of the columns in my spreadsheet has Item Numbers in the form of ABC-123-100X50 for the Prefix ABC and DEF-123-50 for the prefix DEF, What i want to do is have a check that will see if the Prefix is ABC then the string must contain...

I am creating a spreadsheet containing sensitive financial reports that I want to selectively present only to those users who are authorised to view specific reports. I created a "Welcome" page which has a drop down list of internal users to select from. Once the name has been selected (cell...

Hi, I need to check whether the values in column C have specific format and then execute some commands. The specific format is two or three letters, one dash and 3 numbers, for example: AB-123 ABC-345 ZZ-001 RE-909 Is there any way to do this in Excel VBA?

Hello. I'm trying to use the Isnumber function to verify data on a given table, but it does not work on a range of cells. More precisely, i have a table with data and i must make a verification cell where if the values of the data table are negative or non numeric i get a message saying error or...