region

Hi All, I'm in need a of a bit of assistance. I have created a map of my company's regions that I want to use in a larger workbook. To put it simply, if a certain cell changes (it's currently a drop down), I want to change the color of that region to green, and the rest to black, essentially...

<tbody> smith <f4><up><up><up><down><down><down> 15/07/2017 woolworths 30180 1.50 4 120 regiona 180 jones <f4><up><up><up><down><down><down> 05/07/2017 aldi 30180 1.00 4 140 regionb 140 <f4><up><up><up><down><down><down> 10/07/2017 woolworths 30180 1.00 4 75 regionb...

Hello, I have written some code by I keep getting an error "Next without For". Any help appreciated: Sub SelectStocks() Dim i As Integer Dim r As Integer Dim region As String Dim StockCount As Integer Dim lastrow As Integer Dim Ticker As String Dim destCell As range lastrow =...

Hey guys, I have a multiple tables linked together through an auxiliary table since Power Pivot doesn't allow "many-to-many" relationship. So, table A have this "Destination" column where it lists out countries in its field. Table B is this auxiliary table. Table C also have "Destination"...

The Format Cells "Date" settings are behaving... strangely. I regularly pull in data from a reporting system via csv files. The source formatting is always the same, but Excel seems to be seeing something that I am not. When I copy the csv data from the source file to the .xlsx spreadsheet, I...

I'm having issues replicating an international MS Office environment. For the sake of brevity: I'd like to mimic/replicate a non-English Microsoft Office environment in order to test my macro-enabled projects (Excel) prior to releasing them to my international customers. It appears that...

Hello everyone, So i have a excel sheet that is run on alot of computers. Some of these computers have their region set to US date format. As we are in the UK no one would complain about their region settings changed and would welcolm it. So instead of changing over 100 computers region manually...

Hi there, I am trying to create a tracker for my work, I work co-ordinating different types of repair staff around the UK. I have to make a function that allocates what region of the country an entry is for, there are 25 locations and they are spread so; Region 1 : 9 Locations Region 2 : 9...