? Dynamic search and filtering in Excel

Currently I am experimenting with dynamic search bars and filtering in Excel. I have found a nice tutorial that uses a table and Active-X text box. I have recreated it and surely it works. My problem
 ? How to modify xlsread to get a step-by-step updated flag from loading process

I have installed Matlab r2010a on my computerI need use the function xlsread to load data from one just one *.xls or *.xlsx file. that's not a big challenge, the problem is How to modify xlsread.m to
 ? Is variable defined?

Q: How would I go about seeing if a variable exist / is declared in excel, when Option Explicit is on? I am searching for a pattern in a text file and when it finds it, it retrieves the location (char
 ? VBA/Excel - Multiple website scrape returns duplicates

I have been scraping data from multiple websites and pulling into excel the inner text of a specific tag from each of those. The code goes as follow:For Each x In Range("C2:C30")If x <> Blank Th
 ? What's faster for Stata: manipulating data in a flat database (i.e. Excel) or in a relational database?

I'm an entry-level optimization analyst at a company that publishes risk ratings data for various companies. We have tons of data (to the point where our history is currently solely limited by the num
 ? Excel VBA: Adding objects to a collection within a class

I am trying to create a class (named ClassSection) that contains a collection (named DefectCollection). It needs a function to add items to that collection but I'm having trouble making it work. I get
 ? VBA class with a property that has properties

I'm an trying to build a class that describes basically a geospatial conditional statement where one of the parameters is the altitude. Altitude has 4 properties like Min, Max, Units, Invert and I'm t
 ? Converting different date formats

This is continuation of my other question How to convert Quarter years to other formatOk so now I need to convert some more stuff :)I need to convert YYYY-MM to YYWW ex. 2022-10 to 2241 // week 41 bec
 ? Excel VBA zooming range

If Target.Address = "$D$2:$F$861" Then ActiveWindow.Zoom = 100 [A5000] = "zoomed"ElseIf [A5000] = "zoomed" Then 'Otherwise set the zoom to original ActiveWindow.Zoom = 70 [A5000].Clear
 ? Excel Data Connection Updates Cell References Outside Table Range

Say I have set up a data connection in Excel to update columns A-G on a worksheet and sort on column A. If I put a formula in the column H cells like =SUM(B2:D2), then refresh the data connection, th
 ? does power map work with a specific type of data set?

Sometimes when I want to use my data sets on the Power Map, it doesn't work. It recently gave me an error that this operation is not possible with the 32 bit office version and most of the time it doe
 ? does power map work with a specific type of data set?

Sometimes when I want to use my data sets on the Power Map, it doesn't work. It recently gave me an error that this operation is not possible with the 32 bit office version and most of the time it doe
 ? does power map work with a specific type of data set?

Sometimes when I want to use my data sets on the Power Map, it doesn't work. It recently gave me an error that this operation is not possible with the 32 bit office version and most of the time it doe
 ? Data connectivity issue when publishing PowerPivot Excel file to SharePoint, and how to work around it?

One of my customers is very impressed with the capabilities of PowerPivot, particularly the analysis capabilities but even more the publishing capabilities. With that I mean the ability to publish a d
 ? Map Chart works in Power Map but does not work in the Power View Map

I am building a simple map report using Excel 2013 with Power Map and Power View. I struggle to understand why the same data are displayed correctly in Power Map; however, fails to display anything in
 ? How do I get Excel to use Formatted_value in SSAS cube

TL;DR: What (Where) do I need to make changes in order to instruct Excel to use the format string to format the values pulled from the cube?I have a SSAS cube that adds some calculated measures onto a

Page 1 of 975  |  Show More Pages:  Top Prev Next Last