Questions tagged as 'excel'

Tagged questions
0
answers

Graphing

Good evening. You would know how to assemble the graph of the figure below, and in the chart the numbers 1, 2 .... should get the 3 columns next, getting something like: 1 1 of 10; 10% observing that columns that do not have data are simply igno...
asked by 15.03.2017 / 05:22
2
answers

SQL Query in Excel VBA

Good morning! First of all I would like to say that I understand almost nothing of Visual Basic and that everything I have learned so far has been in the race in forums. So if that is too simple to solve, forgive me. Now to the problem. I...
asked by 27.03.2017 / 17:10
1
answer

Prevent the PROCV formula from returning an error

Is there any configuration in Excel or some way to make the PROCV formula, when it does not find the value fetched, return empty ("") or 0 instead of the "# N / A" error?     
asked by 08.04.2017 / 02:33
1
answer

USERFORM: Move ListBox item up or down

I have a ListBox on a UserForm that reflects a list of the display order of items in a Dashboard. I want the user to be free to change the order of these items by moving them down or up in the ListBox, as shown in the figure: Is there a...
asked by 08.04.2017 / 14:40
1
answer

VBA: Filter multiple items of a PivotTable containing certain text

I am trying to run a code that filters all the items in a PivotTable that contain a certain text. I figured that just using asterisks (*) before and after mine keyword would get results, but VBA reads asterisks as literal characters. How do I fi...
asked by 21.03.2017 / 15:18
1
answer

Refresh all PivotTables when selecting a Worksheet

I need all the pivot tables in my worksheet to be updated every time I select one of my worksheets that serves as a dashboard. I used the most logical code, but I think something is missing, since the macro does not run, since it returns "compil...
asked by 25.03.2017 / 14:38
1
answer

Rename a variable and update it for the remainder of the project

Is there any easy or automatic way to update the rest of your code when renaming a particular variable in the Dim line? What I have: Dim ABC As String If Range("A2").Value = 1 Then ABC = Range("C2") & ".xls" ElseIf Range("A2"...
asked by 25.03.2017 / 16:34
1
answer

Association condition E as formatting between numerical intervals

I would like a tip on how to make the equation feasible below: =SE(E($Q1744=W10;8>=$R1744<=12,99);1;0)     
asked by 26.03.2017 / 17:59
1
answer

Concatenate Userform texts and insert as a link in a cell

I am trying to feed a table with 3 information entered from the execution of a Userform and, at the end, make a direct hyperlink in the cell with the information entered. The information is as follows: Path to a certain folder (textbox) Th...
asked by 25.03.2017 / 15:50
0
answers

Import spreadsheet charts for userform (excel vba)

I have to import 3 graphics to a userform. I even got it, but it started to make mistakes, so I put the code "On Error Resume Next" (but this is not a solution, it just does not lock my form anymore, but it does not do what it should do). At the...
asked by 05.03.2017 / 05:23