office

Problem with cascading dropdown list

Contextualization I am trying to create a drop-down list for the cells in the Model column, which depends on the value of th ... c test returned me the correct value vector, while with the dynamic test, it returned me #REF, that is, there was some error.

Apache POI: how do I know if a spreadsheet has ended?

I am developing a personal project, and for this I am using Java along with Apache POI to read XLS files, How can I know if the worksheet has come to an end? Thank you now!

Transform multiple columns into just one [closed]

Closed. this question is out of scope and is not currently accepting answers. ... from 1 to 15 in Column A, is this possible? Result: |A | - |1 | |2 | |3 | |4 | |5 | |6 | |7 | |...| |14 | |15 |

VBA code to delete line

Guys, I have a code that checks the line for the word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> ... ple," modem installation "or" meal", it deletes the line but let the lines that contain the word" defect " inside the phrase.

PROCV between two spreadsheets

The result I should show in the column authors of the production sheet is the name of all the authors who wrote that discipl ... not yet been searched) can exit again. Below I show the columns of the sheet: Production sheet Remanufacturing Worksheet

How to compare two columns and return the sum?

Personal speech, I have the following table below, what I want is for it to add up the price (column D) of all the books th ... le. If anyone can help me, I will be extremely grateful. No more, I appreciate the attention and understanding of problem.

How to update a card-message already sent in microsoft-teams using connectors?

I am developing two microservices, one that sends a card-message to microsoft-teams, and another that receives the action tak ... entire teams back to the request. Above is an example of code forwarding a simple card with the header informed by microsoft.