regions

So I have multiple workbooks in SharePoint, the regions data, that I want to conglomerate in a HQ book. The regions workbooks are secured so that each region can only open their workbook but I have permissions to open all of them. The columns are all the same across each regions book. I want to...

I have a SUMIFS-formula which here gets its criteria-input from two drop down boxes (in my actual formula 10+ boxes). The table has three columns, the "Sum_range" contains sales and then I have the two Criteria_ranges called "Region" and "SalesResponsible". The values in the drop down boxes are...

<tbody> Hello, a simple question about Power Pivot, that I am not very familiar with … I would like to know how I can add (append ?) - and not replace - data in a Power Pivot model. In a nutshell, I analyze 4 great regions (Europe - America - Asia - Africa), each in an Excel file...

Hi, I have 10 tables which represents 10 regions all have individual files, the tables are the same in structure but obviously the values relate to each region. I have created connections for each file and then appended these to make one query table which is easy enough. However, I now...

I've got a drop down list of customer names in C2. Now I'm thinking of adding a new region field in my file in C1. So if I do a validation of regions in C1, how would I get C2 to show only the list of customers associated to that region? thanks in advance,

Hello This is my first post so please forgive me if this is a stupid question. I am trying to merge two sheets with data for geographic regions. My problem is the regions are coded slightly differently in the two sheets. In one sheet, the name for each region is listed as: MB 0000100 MB...

Hello, I am creating a data base in which I need to control the entries for two separate categories. e.g. Regions and counties. I have a column for Regions and a column for counties. My end goal is to have a Userform or list for Regions which pops up and lists all the regions in the UK, and...

Hi there, I have a list of coordinates (latitude, longitude) which I've plotted on excel 3d map. I've also imported a .kml file into my file which shows regions within the same country. How am i able to filter the coordinates or color code them based on whether they fall within the regions...

Good Afternoon all Is there a way to utilize Sumifs with a range/Array of values. Example - Instead of entering each value select a range of cells sum(sumifs(A2:A100,B2:B100, {"West","East","South"}))) I have many more Regions, too many to type & the regions will change.

I'm working with data where I have 2 areas, each with multiple regions, then each region with multiple markets. I'd like to have the user select from the 1st dropdown of 'areas', then the regions available to choose from in the next dropdown will be dependent on the area(s) selected, and the...

Hello team i have workbook, with regions values raw data and pivots, i need to create a separate files based on the regions. NOTe; should not close the main workbook. Please help

Cars can have the start point from everywhere in Region A, it is not set up in which point should a car start. That is up to the formula to decide what is the best point where to start. The last points that cars reach in the Czech Republic are areas with postal codes 3 and 4 as it is shown in a...

Dear All, I have little knowledge in excel, but it made some attempts in summing up all the results in cells into one cells. To be clearer, I have column of writing gender of the people in F and M. Again, the regions of the people are different and they are separated with a row, for example 7...

I have a list of locations, with their coordinates, and I have a set of regions of which I have the coordinates of the border points. Now I would like excel to specify for me in what region every location is. I was thinking of using a nested IF function, but I have up to 20 regions so I am...

Hi, I'm trying to elegantly show all of the rankings for my sales regions in one chart. The only thing I could come up with was a line chart (I know, lame!). Any suggestions? <colgroup><col style="width:48pt" span="16" width="64"> </colgroup><tbody> Computers Industrial Vehicles...

This is an attempt to add some basic shapes to an excel userform.The method I have used relies purely on API Region functions as opposed to the approach taken by andy pope who uses built-in excel shapes copied to image controls. The most difficult part is getting the regions to redraw when the...