All Questions
472 questions
1
vote
1
answer
33
views
With Range("Named Range" & LastRow)
I'm using this code to insert the results of a formula into a cell:
`With Range("A5:A" & LastRow)
.Formula2 = "Some formula"
.value = .value
end With`
I've used this multiple ...
0
votes
0
answers
38
views
Consolidate table values into Pivot table using a table list as the reference to worksheets
I have a 'Shopping list' of items that I want consolidated into a Pivot Table.
The catch is making the range dynamic. The range should only pull data from worksheets referenced in the worksheet "...
0
votes
1
answer
44
views
Dynamic Data Label Range for a Line Graph in vba
I have created a macro in VBA which creates a line chart.
The line chart uses dynamic range names for the X and Y axis which works fine.
However, I trying to use a dynamic range name for the data ...
- 1
1
vote
2
answers
247
views
VBA Code to filter a table and all its columns, whilst typing and ignoring accents
I´m studying interpreting and I want to continue to use Excel as my main tool whilst simultaneous interpreting. I`ve already created a FILTER function and I found a simple VBA Code, that filtered one ...
- 13
0
votes
3
answers
132
views
how do I display an image in an Excel cell based on the selection the user has made in the dropdown of another cell?
Microsoft Excel.
How do I display an image in an Excel cell based on the user's selection in the dropdown of another cell?
The code below stops at the second last line:
imageData = imagePath.Picture
...
- 55
0
votes
0
answers
44
views
VBA-Dependent Dynamic Dropdowns
I’m working on an Excel project with three sheets: one is the main sheet, and the other two are data sheets. I need to set up four dropdown menus with specific dependencies. Here’s what I need:
...
- 51
0
votes
2
answers
195
views
Extract rows of data with partial match in a column from one sheet then populates 2nd sheet with matching row data
I have been trying to get this to work for a good part of a week, but am limited in my knowledge of VBA syntax so nothing I've been able to find has worked. Please help.
I have 4 workbooks. "...
- 13
1
vote
2
answers
61
views
Line chart with VBA, displaying the last 5 values of 3 columns (3 lines)
I got tasked to create a diagram that visualizes the results of the last 5 subjects that get tested. Each subject gets tested in 5 different points, and all of them have the same limit value that ...
- 11
1
vote
1
answer
215
views
Trouble using VBA variables to define Power Query source
PDF Path is the file path to the PDF, removed for confidentiality - code works with this in place.
I am having trouble inserting a variable into the last line of this VBA code. Essentially, I need to ...
- 13
0
votes
1
answer
79
views
Adjust an existing formula based on most recently added column and prior month end date using VBA
I'm currently building a macro to update an inventory file that's updated weekly. Once all the new data has been added for the week, I need to adjust the formula in the totals column ("MTD Chg&...
- 3
0
votes
1
answer
99
views
Access-Dynamic Forms
I have a form "alpha", which I am trying to dynamically alter. My code currently is very simple:
Dim frm as Form
Dim strName as string
StrName="alpha"
Set frm = CreateForm(...
- 150
0
votes
1
answer
71
views
Autofilter xlFilterAllDatesInPeriod"month" runs to an error suddenly
I wrote a code that worked for months, suddenly, yesterday it stopped working.
I am baffled as of what causes the issue.
The error occurs with the Autofilter.
I get a Run-time Error '1004' AutoFilter ...
0
votes
0
answers
30
views
Date format in dynamic SQL - VBA in MS Access [duplicate]
In Access I have this code. Variable data is type Date, however, when I insert it into dynamic SQL code as string it formats date to 18.04.1994 whereas SQL date needs to be in US format 04/18/1994.
...
0
votes
3
answers
144
views
Inserting Columns in Two Locations, multiple times within worksheet
I have a worksheet that contains various data, and two ranges of columns containing months X, Y, Z, etc. on same rows, one for cost spent and one for cost invoiced.
I have written code that duplicates ...
- 1
0
votes
0
answers
77
views
Change individual values based on total or %
Ability to adjust the total budget at the bottom OR adjust the brand/spend share % for each row OR put in absolute spends
I have two plans in my data. Plan A and Plan B. Plan B is pre-populated with ...
