I've been stuck with declaring a variable to a cell value and need some help.
Situation: I have a code that filters a table and transfers the filtered data to another sheet. The filter could be the date value but I can't set it properly. The result is always Error 1004.
Previously, I have done an Advanced Filter query, with the Extract in the same Workbook, and:
1.) Sorted the Extract
2.) Made some changes to the Extract
Sometimes this had a bad effect: With whatever change I made, it did the same thing to the rows above and below it - unwanted changes
ActiveSheet.Range("$A$8:$AH$1894").AutoFilter Field:=1, Criteria1:=Array( _
"NOT STARTED", "ON-HOLD", "STARTED"), Operator:=xlFilterValues
ActiveSheet.Range("$A$8:$AH$1894").AutoFilter Field:=2, Criteria1:="NCR"
The Code above is working to filter only "NCR" (after Field...
I would like macro to select the filter in A2 (Financial Year") on sheet summary if Cell c10 on sheet "Data" is zero, otherwise select highest year from Filter
Your assistance is most appreciated
<b></b><table cellpadding="2.5px" rules="all" style=";background-color...
I have a pivot Table on sheet "summary"
Where the value in C10 in sheet "Data" is zero, the year to be selected on Pivot filter in B2 must be blank , otherwise select highest year
It would be appreciated if some could provide me with code to do this
Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this
I understood all the above but what I do not understand, when I use a regular filter to filter...
Does anyone know why the DAX below is not working? Do I have it in the wrong order?
BTS Actual = CALCULATE(COUNTROWS('Schedule','Schedule'[Actual Count]),
USERELATIONSHIP('Calendar'[Date],'Schedule'[Actual date performed]))
Power BI just keeps...
Hi I have the below code(below) that works off a button, to copy an entire row it works fine, however for some reason When the sheet is filtered, it just inserts a blank line, any ideas?
Dim MyPassword As String
MyPassword = "Yes"
If InputBox("Please enter password...
Hi - does anyone have a working VBA code to automatically reapply a number filter on greater than 0? I have tried 3 or 4 codes that I found by searching but none of them actually seem to do anything! It is possible that I'm doing something wrong in the applying of them though.. :confused:
I have a table in which currency in A and values in B
I enter text CAD in C1 and make data validation list in D1. Based on text in C1 data validation only shows the value against CAD. like image attached.
I have a code that shows all data on a filter but how can this code be modified to show all data AND remove the filter?
If (ActiveSheet.AutoFilterMode And ActiveSheet.FilterMode) Or ActiveSheet.FilterMode Then
I have to use this multiple times throughout the code.
I have a list of Email Addresses in an Excel File along with other columns. I Filter the email column to search for mistakes, like double periods (..) which works fine in the filter. But when I search for a comma (,) it's not allowed. Sometimes people type a comma for the period (by accident)...
This is a bit frustrating. I've applied code to filter data using the autoFilter function but when I apply a new line with AdvancedFilter it appears it clears the filtered range and copies over all data
With Sheets(1).ListObjects("Table13256").Range.AutoFilter Field:=22, Criteria1:="<>"...
I wanna select rows and delete them without using filter.
The reason is that the Model No. is common but customer code is different and sum of required qty. is also different.
So i want to keep only those customer code rows which sum is greater than other customer code rows.
I have a very large...
I have a list of prices, products, customers, etc. that are in categories (Beef, Chicken, etc.) and in subsets (Salisbury, Ground, Raw, etc.).
I am using the Aggregate function to determine the lowest price.
Then, I use the VLOOKUP function to search that lowest price for who is purchasing...
I have a spreadsheet that has about 100 Items in which there is a Header Row for each item and then sub items that breakdown these Items into smaller items by areas. Each sub item total equals the Header Item total. Is there a way for me to filter this spreadsheet so I can get summaries of each...
I have a pivot table with 2 columns. Column A is "genre" and Column B is "count". All together there are 211 films counted across all 10 genres. 4 of the individual genres have a count of less than 10 as a result and I need to lump those results into a new genre called "other". The result...