Populate a validated cell if another cell contains specific text

I have a spread sheet that includes a cell containing text. There is another cell that has data validation applied, lets say the list of acceptable values is “A,B,C,D”. Lets say the cell/column containing the text is F4 through to the last populated cell in the column. Lets say the cell/column containing the validation list […]

Auto increment in vb.net

I am using visual studio 2013. I created a windows application form in visual basic and using that I am entering data in excel. I wrote a code to auto-increment a unique number which needs to appear as soon as form loads. But instead of appearing at that time, when i enter first data through […]

Double Click on Edge of Cell Jump (How to Disable?)

The code takes an active cell and if it is in the appropriate column, and has the value “YES” it runs one of two codes (depending on whether it is a summary or an individual value). This done on ‘raw’ data that is not in a table or pivot table. About half the time that […]

Testing wether column values is =0, Then

I’m trying to use the below code to check if a column is empty, and if it is, it should be deleted, but it gives me a Range Error. What am I doing wrong? Sub Hide() If Range(E3, E1549) = “” Then Columns(“E:E”).Hidden = True End If End Sub

Copy contents from a specific cell to an empty column based on number of rows from cells original column

I am currently faced with the task of inserting a column every second column, replicating the contents of cell into the newly inserted column for the range calculated on the number of rows from where the original value was copied from. Repeat until all inserted columns have a copied value inserted. See inserted images for […]

Writing a formula in a cell that checks if two cell values are equal but making one exception

I am trying to make a list that compares two cells in the same row, in two different columns of a table and check whether the values are the same. I am facing a Problem when the value of one cell is 0 and the other cell is empty. I used the following formula: =IF(OR(AND(H6=N6;P6=”Matched […]

Shift rows Apache poi Not shifting the Drop down list in the cell

I am trying to shift the rows in excel. I am able to shift them but Drop down list is not shifting. Any Idea?? sheet.shiftRows(33, sheet.getLastRowNum(), 30)

Excel VBA debugger stops without error or warning

While trying to test some code, I am having an issue that I don’t recall running into before. When I step through the code it halts after the ClearContents line…there is no error, no warning, nothing. Public Sub CreateCurMth(wsCur As Worksheet) Dim iData As Integer, iRow As Integer Dim wbData As Workbook On Error GoTo […]

Apache POI – XSSFWorkbook

I am trying to update our code to use XSSFWorkbook instead of HSSFWorkbook. I have the following jars added to the project: dom4j-1.6.1.jar poi-3.11.jar xmlbeans-2.3.0.jar poi-ooxml-3.11.jar When I try to run the part in the application that creates an excel sheet for our customer I get the following stack trace: java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTWorkbook$Factory at org.apache.poi.xssf.usermodel.XSSFWorkbook.onWorkbookCreate(XSSFWorkbook.java:383) at […]

VB script insert data in to another worksheet using values of ADODB record set

I have to insert data from one worksheet to another using VB Scripts ADODB model. As of now i have queried the excel and have obtained the record set containing the values with multiple rows. I have to insert these values into a blank worksheet say Sheet3 beginning with the top most row. Please help […]

MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.