excel

I need to create a macro in EXCEL that goes to a cell that has a text, and brings me a piece of this text. The problem is th ... that finds the NAME: and brings everything up to EMAIL: and paste that into another cell, like: NAME: JOSH IDNUMBER: 098766

I have a program that reads data from a text file and exports it to an excel report. I am having a problem in the transcript ... e right way? OBS: Already I tried using NumberFormat = "0.0"; Or NumberFormat = "0"; And the results were " 4.7 "

Good afternoon, guys. I created a database for control of receipt and delivery of Cards. The inclusion of data is carried ou ... s presented below: The error is pointed out in the penultimate line of the report function where the " rs.Open sql, cn "

I have the following sheet as image below, I would like to create a VBA to check if the content inserted in the cell range of ... use conditional formatting because the added numbers are always dragged to other cells in some revisions of the document.

I need to calculate the present value equivalent to Excel formula, I have the following data: VP (2,5%;48;-2052,50) which i ... tion I found, but it didn't work. function PV(rate, nper, pmt) { return pmt / rate * (1 - Math.pow(1 + rate, -nper)); }

I have the following script to perform an export of a table to excel: <script> function fnExcelRepo ... nd my result, is shown in the image below: I would like to know how I can remove the last column ("actions")? Thank you

I would like to know how do I export a table of my html code to excel while maintaining formatting (colors, borders, etc). I ... font-family: "Muli"; line-height: 5ch; color:#000; text-indent: 0.5em; transition: all 0.2s ease-in-out; }

Good Morning, I have an Excel file with two worksheet, in 'Plan1' all data is deleted, and a MACRO I made, imports a TXT fi ... = Plan1!A5 'same as the' = Plan1!A5 ' has been deleted. I'm already ahead of myself, the CIF (cipher) does not fit for this.

Sorry for my ignorance on the subject, but I'm developing a Python script that reads Excel files to get certain information i ... dering if xlrd is capable of reading xls files as well, which is an older Excel user format, could someone help me with that?

I'm trying to create a condition but I'm having difficulty, can anyone help me? If the number of cell c15 is between -00:10 ... ld appear 0:00, otherwise cell d15 should show the same number of cell c15. How to Mnet this condition. Since now I thank

I am creating a spreadsheet from Excel using phpExcel(). When placing filters, the result of the cell C3 and C4 where the sub ... codings, including UNICODE-UTF8, ISO and WINDOWS. When I save the file in .xls it works, but I need let it be saved in .xlsx

I am in need of a help to make a formula in Excel. =SE(C11<=6;"G4";SE(6<C11<=10;"G6";SE(10<C11<=16;"G10"))) ... eater than 6 and less than or equal to 10 write G6. If the cell C11 is greater than 10 and less than or equal to 16 write G8.

I need a formula in excel that identifies intervals, ex 0-30 = 20% 31-60 = 98,5% 61-90 = 100% 91-120 = 101,5% If f2<= 30 Report 20%; if f2>30 and <60 report 98,5%, etc How do I do it?

Edited: Guys, this is my Excel file. I want the last value of each month of Column A to be referenced by column C, i.e. for ... 8206 30/06/1992 1,9035 30/06/1992 1,894701 31/07/1992 1,9200 31/07/1992 1,916501 ... Any help/intuition? Thank you.

Due to repetitive actions with groups of objects that I create to work as if they were a single object, I grouped some of the ... tle experience in event or object oriented languages, so I believe you have a more appropriate way of dealing with this case.

In a C # application, which can have from 1 to 2100 hours of data collection. The data is saved in an Excel CSV spreadsheet e ... e saved. What is the smart and intelligent way to prevent this file from being opened until the data collection is finished?

I am developing a macro in excel that through a list of IDs and passwords in excel logs into a website and tries to download ... t;br></td> VBA to open pfd: objIE.Navigate "javascript:obterFormulario('','')" I thank anyone who can help me.

I have a file with multiple arrays as described: Name Value lat <162x168 single> lon < ... e> I want to send this data to excel or cvs. I tried several commands without success. Has anyone ever done this export?

Oi! I am having problems with this error. credit that eh some problem in the data Q entered, but I can not arrange. Cal ... k) + NeigeMens((12 * (k - 1) + 8 + j)) Next TemperAnnHy(k) = TemperAnnHy(k) / 12 DebitAnnHy(k) = DebitAnnHy(k) / 12

Hello! I am something new in VBA and have been getting what I want through macro recorder. However, I think that in this case ... n "CLOSED" and paste them into a table located between A1:L16 on sheet "AÇÕES PDCA FECHADAS". I appreciate all the help now!