markets

Hello, is there a way to sort a combo alphabetically? I'm not sure if this needs to be done before the box is populated or after. Right now, I am building a list of unique values in ComboBox2 based on the selection of ComboBox1. The last thing I add is an "All Markets" option, which...

Hey community, i use following VBA Sub BonaquaASM1()Application.ScreenUpdating = False Dim Markets As Worksheet, lr As Long lr = Cells.Find("*", , xlValues, , xlRows, xlPrevious).Row Set Markets = Sheets("sheet4") Sheets("DATA").Range("A1:A" & lr).Name = "run"...

Hey Dear community, I am using VBA+ formulas to analyz sales data ( about 1000,000rows ) it takes 7-8 minutes for calculation, i wanna know if there any other way to make it faster? because i need to calculate this report daily. I use following VBA for 80-90 different ranges on that report...

I have all of the data from our third-party analytics tool - all in CSV files. The format comes out as this: Excel 2013/2016 <tbody>#DAE7F5[/URL] "] A B C D E F G H I J K L 1 Media Impact Origin Market Breakdown 2 Advertiser Visit Britain 3 Date Range Jan 1, 2018 -...

Hey all, I have a few report i extract daily and clean up in power query to give me a neat table with the data i need. Now as i have different markets i need to extract the same report multiple time for all markets. So the report structure does not change only the output data is from another...

Hey Dear community, i use this formula =SUM(SUMIF(D:D,A2:A10,E:E)) to find markets total income D:D whole market names , A2 to A10 name of markets which i need to calculate. and E:E is income from markets But data is very huge and array formula wont work. Can anyone help me to do it with VBA...

Hey Dear community, I have very big data, where i need to count income based on markets, but there are some group of markets in my list with different names, i have already grouped them. ( for example N-market 1 , N-market 2 , N-market 3 ) So all N-markets are in A2:A10 How can i ask excel to...

I have a project that I am trying to work on for the owner of a contracting business and have some confusion on how to work this out. I work with electrical contractors to buy wire... The price of these products are directly related to the market. However, the only thing I have to start with...

Hi everyone I'm really new to power query and have created some basic code to scrape a table from a website (mainly through the UI with a couple of tweaks in advanced editor). It's a really great tool, especially for people like me who don't really know how to code. However, because of the way...