Most voted "excel" questions
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X that allows advanced use of mathematical formulas and functions and statistics. For questions about programming in VBA Excel, also use the excel-vba tag. Note that non-programming issues are within the scope of the Stack Overflow, for example those involving the basic use of the tool.
Learn more…1,117 questions
Sort by count of
-
0
votes1
answer1488
viewsError 381 listbox.list VBA
Hello! Basically I need to add up the values of listbox, only my program is showing the following error. Runtime error '381': Could not fetch List property. Invalid property array index. Private Sub…
-
0
votes1
answer55
viewsGet the address of Cell Crossing Worksheets in Excel
At Book1 we have Sheet1, and Sheet2 At Sheet2 we have these values: In Sheet1 in cell A1 we have this string: asc-7 ; in cell A2, we have the formula:…
excelasked 5 years, 6 months ago texugo_indy 13 -
0
votes1
answer38
viewsSet value in excel based on a drop down list
I need to make a drop down list in excel in the following style: Merchandise | Value In the same spreadsheet I have a table with a list of goods and their respective values. Below the merchandise…
excelasked 5 years, 6 months ago Rodrigo Rossi 83 -
0
votes1
answer83
viewsHow to change position values for a given resource?
Another Hardcore challenge, I don’t know if I can explain it well, but here it comes. In the table below, I have the resource "X", where he has already made 8 contacts( 5 completed and 3 not…
-
0
votes0
answers72
viewsExcel VBA - strange behavior!
Strange behavior in VBA Excel! The code opens a source file, and copies an existing table. Pastes the Table into a target file - in the SUPPORT sheet - and closes the source file. In the destination…
-
0
votes1
answer72
viewsLaravel Excel I do not understand what is being filled
I do not understand what is happening in this code that fills a cell B8 in excel: $sheet->cell('BQ'.$i, function($cell) use($report) {…
-
0
votes1
answer614
viewsSum values from a date in Excel
I have an excel spreadsheet with two tabs Aba Cálculo Aba Valores In the Calculation tab you have a field to date. In the Values tab there are two columns one with the month and the year and the…
excelasked 5 years, 6 months ago Alê Moraes 883 -
0
votes1
answer1101
viewsAuto-increment in Excel, based on line value
I have the following cells and columns: It needed to create an auto-increment, in column B, increasing only when the value of column A is different, starting with "1". Column C shows the desired…
excelasked 5 years, 6 months ago Duarte Miranda 13 -
0
votes1
answer791
viewsHow to count consecutive values in Excel?
Right now I have this formula that calculates consecutive values: =SE(AB5=0;0;SE(OU(E(AB4>=100;AB5>=100);E(AB4<=-100;AB5<=-100));AC4+1;1)) Basically she does this: 0 0 0 0 -110 1 -110 2…
excelasked 6 years, 6 months ago Fábio Linhares 109 -
0
votes2
answers2460
viewsExport. xlsx with Java
I am trying to export a spreadsheet with Java, specifically a file .xlsx, but I’m not getting it. I’m doing it this way and it’s working, but it only works by putting the extension .xls:…
-
0
votes1
answer1384
viewsSleep or Wait function catching spreadsheet in Excel
I am programming a macro in vba, which makes the connection to a sql server database and makes a select in a table and returns me the time of the last change in the database. I created a program in…
-
0
votes1
answer347
viewsError at runtime. Failure in attempted VBA Outlook operation
I created a macro to run a routine in outlook. The code works perfectly on a PC, but when I replicate the code to another macro I get the following message: Runtime error '-2147221233(8004010f)…
-
0
votes1
answer1319
viewsVBA to send email
I have a VBA code to send a range as image, by outlook. But he doesn’t always glue the image to the email body, but to some part of the spreadsheet. Is something wrong with the code? thank you Sub…
-
0
votes2
answers4373
viewsUse VBA to delete lines with a cell-determined criterion
I need a Vba that does the following action: The moment it is activated, read a specific cell and delete lines from another tab taking into account the specific cell as a criterion. Example: In…
-
0
votes1
answer114
viewsHow do you translate this English excel formula into Portuguese?
The formula is this: = IF (E2 = 1, SLOPE (OFFSET (E2,0, -1, ninbox, 1), OFFSET (E2,0, -4, ninbox, 1)), ””) I’m using the following, which is not working: = SE(E2 = 1; INCLINAÇÃO (DESLOC(E2;0;-1;…
-
0
votes1
answer1236
viewsSum values with PROV
I have an Excel sheet with monthly spending per food. The goal is, on a separate sheet, to calculate the sum of each food in every month. With the formula I’m using right now…
-
0
votes1
answer112
viewsJXL generate excel spreadsheet with decimal value in the Brazilian standard
I am using Java and Jsf on my system and there is a screen where you have the option to generate an excel spreadsheet. Worksheet generation is ok. The problem I’m encountering is in columns that…
-
0
votes1
answer31
views -
0
votes1
answer446
viewsCopy lines and paste based on a value in an excel cell
I would like to know how to copy a set of lines. For example, line 1 through 5 and paste on lines 10 through 15. This action would be done with the value 1 in another sheet and in cell A1. I have a…
-
0
votes1
answer123
viewsIt would be possible to create a string that has more than 256 characters in VBA
Can a variable of type string and need to save around 1k of words to send as parameter to a database, I would like to know how to do this. Actualemente meets thus my variable: Dim variavel As String…
-
0
votes1
answer23
viewsMacro and VBA that deletes the oldest records, if they are the same value
Talk, guys, I’m new here and I’m desperate for some help. I need you to delete the oldest records from a list of multiple trips, keeping only the latest of them. The print below makes it clearer. In…
-
0
votes1
answer48
viewsHow to search for phones with Autofilter in VBA
I am using VBA to apply a filter in the phone numbers column. The phone numbers are treated in a personalized way to stay in the model (XX) XXXXX-XXXX or (XX) XXXX-XXXX I take the value of a cell…
-
0
votes1
answer30
viewsI have a code in vba that when running shows error 438
Sub buscacep() Range("B3:D3").ClearContents Set ie = CreateObject("InternetExplorer.application") ie.navigate "https://www.achecep.com.br/" ie.Visible = True Do While ie.busy And ie.readystate…
-
0
votes0
answers45
viewsC# - Reading Excel
I was able to read an excel file, but when showing console the information does not leave spaces, how can I give space in the middle? kkkk using System; using System.Collections.Generic; using…
-
0
votes1
answer31
viewsExtract part of email cell text
How can I extract part of the email after the last "."? On the first line, I get what I want. On the second line the problem is that it is extracting after the first point and not the last. With the…
-
0
votes1
answer17
viewsGenerate list in another tab with found data
all right? I am a beginner in excel and need your help to create a spreadsheet that generates a list in another tab based on the found result. When I set a date, I need you to copy the corresponding…
-
0
votes1
answer32
viewsVBA to seal cell, complete
Good evening, I am preparing a VBA record sheet and I would like it, when selecting a specific cell, to be filled with an X and delete the other possible alternatives ... If possible, I would like…
-
0
votes0
answers12
viewsHow to select the lowest value in a given vba range?
Good afternoon, I am having a problem in a part of the code in which I need to select the lowest value of a given range. I need to select because I will have to use offset to find out the value…
-
0
votes1
answer901
viewsVBA - Generate a multi-excel PDF file
I am trying to make a code to generate a PDF for each Excel file I have in a folder. First my code generates a PDF each excel file and then generates a PDF that would be the cover of all these…
-
0
votes1
answer983
viewsThe Value method of the Range object failed
Good evening, I’m making the following mistake: The Value method of the Range object failed The complete code is found here: By the Ghostbin Private Sub CommandButton2_Click() ''' Botão "CADASTRAR"…
-
0
votes0
answers35
viewsAccess to remote server denied because there is no login mapping
I’m trying to access data via Excel that searches the data in the database. Only when consulting the data gives the error below: When seeing the details of this error Detalhes: DataSourceKind=SQL…
-
0
votes0
answers93
viewsWhen trying to generate in Excel by PHP, appear Warnings and spreadsheet is printed in the browser
Since youtube tutorial, I am trying to generate an Excel of my BD Mysql through a PHP query. But the sheet is not downloaded and the result generates 5 warnings of header with the sheet printed on…
-
0
votes1
answer37
viewsHow do I remove this black box when I press quotes?
Next, I’m learning a little VBA and there’s a business that’s bothering me too much. Every time I start some line with ' or ", the VBA opens this black box: In it I can write the rest of the code,…
-
0
votes1
answer25
viewsVBA - Error checking cell value
Good morning, I have the following code IF returns "incompatible type" error, anyone know the reason? I’m trying to validate row values with columns. Sub DeleteColumnByHeader() Dim aCell As Range…
-
0
votes0
answers57
viewsxls created through C#, but does not add values
I have a method that generates excel(. xls), but I have a problem: excel is being generated perfectly, but when I try to add up the values of cells nothing happens, it only adds up if I open cell by…
-
0
votes0
answers32
viewsHow to create a generic method for reading xlsx
I would like to create a method that reads an xlsx file with different data and save according to the given object. Type: Public Reader Object (object Object, file xlsx) { //Implementation } I have…
-
0
votes1
answer15
viewsAutomatic Excel caption (empty series)
In my spreadsheet I have a chart that currently receives 46 series. All series are linked to databases that depend on a single variable, so when choosing the variable some of the series return #N/D,…
-
0
votes1
answer15
viewsSUMIFS + INDEX MATCH with repeated matches
I have this table with repeated Tecs (column A), related to different products; I need to add the total of the week (from 19/4 to 24/4).. I’m using the formula below, but it only adds up the…
-
0
votes1
answer124
viewsFixed Range Macro Problem
I created a macro to select cell information from a dynamic table and copy to a new table. Sub tabela_tratada_3_var() ' ' tabela_tratada_3_var Macro ' ' Range("D1").Select ActiveCell.FormulaR1C1 =…
-
0
votes1
answer32
viewsHow to reference properties of a userForm to a sub in excel?
I created a form in vba (excel) and in this form contains a checkbox, I would like to trigger a given command if the checkbox is marked, however the code to be triggered is in a module sub separate…
-
0
votes2
answers384
viewsHow to make a ranking of the best buyers through Excel?
I have an Excel table with 15 thousand lines. Each of these lines means a product sold. The layout is like this: Produto - Nome do comprador - Valor do produto I need to make a ranking of the five…
excelasked 6 years, 3 months ago Felipe Viero Goulart 3,693 -
0
votes2
answers58
viewsImport Excel data to table in SQL Server (only data other than that already in the table)
I just want to add different records than the ones already in the table, that is, they would only be records from Idcollaborator 10.…
-
0
votes1
answer34
viewsHow to separate data that is in the same column in Rstudio?
Good evening, I have a table that I imported from excel to Rstudio and I want to work with the "Date" column. I need to separate the date from the hours and so far have not succeeded through the…
-
0
votes1
answer203
viewsExcel "If" function giving problem when checking if all values are true
I used the "If" and "Cont.se" function, but I wanted the "If" function to check if all sequence values of (C69:C73) are ="500", however when checking the penultimate value it considers that all…
excelasked 6 years, 2 months ago Elienay Junior 527 -
0
votes0
answers110
viewsCopy Excel Data to Drive
Good morning, need to select data from a file Excel copy, open a file in Google Drive and paste the data. Sub ActualizarDrive() 'Selecionar Ficheiro Windows("Lojas_Pendentes_CCTV.xlsx").Activate…
-
0
votes1
answer781
viewsHow to change the shape of a cell with Pyhton and Openpyxl?
All right with you? I am working with the transposition of databases from one Excel file to the other, and when transposing the values to another file, I would like to set the types of values of…
-
0
votes1
answer18
viewsShow some columns in Listbox
I am building a system for my company, where when I click on a button it is bringing me all the columns of the table, but I would like to specify which columns I want to display. Since these columns…
-
0
votes2
answers678
viewsConvert an excel file (xls, xlsx) to PDF
I have to convert an excel file (xls, xlsx) to PDF, however I am looking for a better way, however I am not sure if the following example is the best for me:…
-
0
votes1
answer2299
viewsHow to convert textbox to number and date in VBA
I have a vba in Excel, however the command saves the entries as text, so it is not possible to apply any formula. I’ve done some trials and research but all of them were failed, follow the codes:…
-
0
votes2
answers51
viewsCheck whether certain parts of a spreadsheet have data
I have a spreadsheet that has two parts and I want to check if both have data. If the Part 1 and the Part 2 have data, the code paints the corresponding yellow line. If only one of the parties has…