All Questions
818
questions
0
votes
0
answers
45
views
Excel VBA transpose/filter to other sheet
I'm trying to automate the sets of data. So far I have this code that filters the data to another sheet but I cannot figure out how to transpose the data vertically. I've tried adding Transpose:=True ...
- 1
0
votes
1
answer
83
views
How to copy and paste data into n new workbooks based on two filters with VBA?
My goal is to copy and paste data from 1 Master workbook into n separate workbooks.
The user should be able to select a "Desk" in the Master which then triggers the creation of X amount of ...
- 107
0
votes
1
answer
86
views
VBA Macro for Exact Match Filtering
I have a VBA macro that filters on 6 differents criteria, but I'm encountering an issue where the filter includes partial matches. For example, when I filter for the element 1 "G56", it also ...
- 1
0
votes
1
answer
56
views
VBA code is not copying the full set of data
The below code is supposed to copy all matching REGION rows with e.g. ASIA (EX. NEAR EAST), but for some reason it doesn't do anything if the first row (non-header) is not "ASIA (EX. NEAR EAST)&...
- 107
1
vote
1
answer
55
views
How to filter an excel date column using VBA?
I’m working on a VBA script in Excel that filters a range of cells and then prints the filtered rows. However, I’m encountering a runtime error and I’m not sure how to resolve it.
Date filtering : For ...
1
vote
1
answer
48
views
MS Access 2016 - Yes/No field
I have a simple form (Form1)which opens behind a command button. I would like to set the command to a macro but I cannot get it to work so I need some help with VBA - Form Load.
So basically I want to ...
0
votes
1
answer
26
views
VBA Autofilter partial match in two column
I want to use the autofilter for partial match in two columns, it not works for two columns but works for one column.
May i know if how to filter number with character?
As Mws.Range("E5")....
- 53
1
vote
2
answers
96
views
Filter out and delete multiple criteria
Posting in the hope I'm not flame grilled. Bluntly, I'm a novice and though I'm trying my best, Rome wasn't built in a day and I'm stuck.
I've had some help elsewhere and Kudos to the person, they are ...
- 11
0
votes
1
answer
46
views
VBA filter pivot table with wildcard array from named range
I'm currently struggling to get a dynamic filter to work.
Initial situation: Pivot Table where i need to filter for multiple different words.
It is always build like this:
7.06610.14.0 EDR-E -> i ...
0
votes
2
answers
120
views
Pull Data From Multiple Sheets Based On Sheet Name
I have a an Excel Workbook with multiple sheets. These sheets are organized as follows:
'Company1','Company1 News','Company1 Jobs','Company2','Company2 News','Company2 Jobs','Company3' ...
I need to ...
- 29
0
votes
1
answer
69
views
How to Use VBA to Filter a Pivot Field (Data Model)
I am attempting to write code that will allow me to filter out a single item from a pivot field. My pivot table is built from a data model and not from a regular table. I believe this changes things. ...
1
vote
2
answers
38
views
Copy the result of a filter from 2nd line
I need to create a macro to make a filter, copy the result of that filter from the 2nd line and paste it into another sheet. I've tried everything (offset, usedrange, sendkeys) but nothing worked. I ...
1
vote
2
answers
70
views
Access sub to update a single record always updating the first record in a table
I have an unbound form displaying fields from a table in my d/b. The user may select images and store them in a working folder by clicking the "Browse..." button. The button should also ...
- 13
1
vote
4
answers
135
views
How can i obtain the row number of the first item in a filtered table with VBA Excel
I have the following in the attachment
i tried to use the following macro to obtain the number of row of the first item when i filter this list to "Retail" only. the macro should show a ...
- 11
1
vote
0
answers
24
views
Excel VBA code is clearing Pivot Table Filter
Can someone please review my code and tell me what is causing it clear the filters on my pivot tables before converting them to text?
For reference, this code takes a 20 sheet workbook, converts all ...
- 35