Questions tagged as 'excel'

Tagged questions
1
answer

Text split in excel

I have to split the "Full Name" cells of my table in two. So I used two functions: "Left" to get the Name of the person and "Right" to get the last name. In which, everything that is until the first space is considered a name, and everything...
asked by 02.10.2017 / 19:59
1
answer

use excel spreadsheet to fill web form [closed]

I have a spreadsheet in Excel, it was generated from a form on a system and then some data was selected. After that I have to put this data in another web form, this form is in another system than the one that generated the initial worksheet. To...
asked by 23.11.2015 / 02:06
1
answer

As per comments in the user defined function in Excel / VB

I'd like to know how to help with user-defined functions in Excel. It is not how you create the user-defined function , and yes how you add instructions as the user should manipulate it.     
asked by 23.03.2017 / 12:01
1
answer

Calculating with Excel times are not very accurate

I have a worksheet that calculates the hours that a company car is used in a month. Each race is marked start time and end time taking intervals of 30 minutes. At the end of the month I then have a table with the used times of each that ar...
asked by 07.11.2014 / 16:46
1
answer

Doubt in string comparison and list value for all rows

I have a table of 5 rows and 5 columns. For each column I have a name, for example: Name, Age, Sex, Weight, Height. And all 5 * 5 cells are filled. I need the following formatting: Idade João - 15 José - 16 Maria - 21 Sexo João - M José -...
asked by 27.08.2014 / 16:24
1
answer

Importing data from a web page to Excel via VBA

It's the following: I found the code on the internet that works perfectly with what it's indicating, but I need to adapt it to a project and I'm not getting it. In short, the macro accesses the link page, verifies the member search form, us...
asked by 26.12.2015 / 22:52
1
answer

Bug in code, function repeats call when open excel file

Following this question: link Code: Function PrinciQualidade14(LNumber As Integer) As String If LNumber < 15 And LNumber > 0 Then InsertPictureInRange LNumber, Application.ActiveCell Else Debug.Print "Numero incorre...
asked by 12.02.2016 / 17:51
1
answer

How to get values in function of another value?

I want to sum the value (and show in any cell) of the cell Cx when Dx is equal to 1 and add the values of Cy when Dy is 2. For example: In the photo, when the value of cell Dx is 1, I want the value of Cx (of the same line) to go to L3 and th...
asked by 17.03.2018 / 00:08
1
answer

Excel - Create QR Code with data of 4 cells

Good, I'm trying to create a document in Excel that will fetch the entered data for example (B1, B2, B3, B4) and with this data generate a QrCode. I do not have any software yet that creates QrCode. I do not know if they recommend one. Tha...
asked by 24.02.2017 / 13:52
1
answer

Dividing integers in MS Excel (exact division)

I have a problem in Excel that I thought would be easy to solve, but so breaking your head is this: I have a request grid, for example, 2,010 pairs, and the production control and production order is 10 in 10, I need to calculate how many produc...
asked by 29.05.2015 / 20:14