map

I have a long list of check, change/replace items. once the values for N have been found has been updated I want to leave the NEXT loop and restart the search on the next number, and for the life of me I can't find a way that will restart the search with an increment What did I miss (tried Next...

Hi All, So I built this cool VBA coded heat map in Excel BUT...... having moved to a new role they do most of their work in Google Sheets so they can be collaborative. Problem is I need to recreate my heat map but, obviously, Google Sheets does not rely on VBA (it's Javascript instead isn't...

Hi Everyone, I've signed up on the site as I cant figure out how to do this for the life of me. I'm trying to accomplish some sort of a heat map in excel where the values change depending on where the you hover in the map. For example, using the image below. If i hover over number 1 it will...

Hi, Need help creating a formula that can look an transpose values to another individual worker table. Monthly Map to Individual Anual map xls template : https://expirebox.com/download/bca11da36f75610ae19e271ab7f8f74d.html a / b / c/ d are tasks Thanks in advance...

Hello, Hope you are well. I'm getting ok at this VBA stuff. But not that good. So I have some code here that is designed to insert column next to a column that will always have the header, "MSRP". If it returns finds a column with the header, "MSRP", what I want it to do is return the MAP...

I have a large list of: Property Name Address City State Zip # of Units Is there a way to create a map of all the properties in Excel? Either using an Add-On or Download software?

Zip Codes, the New England section of the United States where the zips are truncated in excel like 01001 or 01002 end up in Europe after I load them into the map. I thought it was because the first zero was truncated, so I formatted cells with 0####. However this still does not work, and the...

Hi guys. I'm looking for an Excel-based game "Capitals of Europe" (or sth like that). There was a map of Europe (just the outline of the countries) and the game would ask you questions like: "Where is the capital of Romania?" And then you would indicate a spot on the map and click and a dart...

Can the logic below be made into a formula? Formula in cell U2 If S2 is blank and T2 is blank then U2 is blank If S2 is populated and T2 is blank the map S2 to U2 If S2 is populated and T2 is populated, then map S2 to U2 If S2 is blank and T2 is populated, then map T2 to U2

Hi All, I am currently working on a setup where I would like to filter 3 columns and copy the resultset to another sheet (insert below last row) Sub STEP2_Copy_new_contracts_to_manual() 'copy contracts which are indicated as COPY TO MANUAL from tab POWERBI_IMPORT to Manual map AGR-Crop Dim...

I have a set of data for the state of Texas. Column A has unique zipcodes, column B has counties (not unique since multiple zipcodes fall into each county), and column C with a population metric (there are duplicates since data is county population). I want to build a map that fills the...

Hi, I need help to open the files in sharepoint O365 site. "https://..." I got some codes from the internet however, it will not work on the other pc with limited features because it needs to map a network drive. Is there a way that there is no need to map a network to make it work in...

I'm creating a dashboard that shows trucking lanes (picture a line image) on top of a map. My vision is to have the lines change colors based on a reference table <-- this part seems straight forward. But I'm struggling with the 2nd part of the vision -- I'd like the dashboard user to be able...

Hello, I would like to find the name of an xml map by first selecting a cell in the xml table. Is there an easy way to find the xml map name based on the range that I specify? Thanks Matt

Hi All, I needed to create a heat map in my pivot table. My data comprises of actual sale, budgeted sales. i want to create a heat map to show which product are performing above the budget and below the budget in a color format( like the heat map) but i want to show the actual sales in the pivot...

After successfully import KML/shapefiles into Power Map Excel 2016 via "custom region", those ploygons do not show up on the map at all. Note that those KML/Shapfiles are fine and can be successfully displayed in other GIS softwares. Does someone have 2013 and power map who maight want to try...

I created a map with 3 d Map Montreal's uiing open data for 311 calls, I selected a subset for calls regarding calls for rat extermination. The data has geo location for each call. I then tried to amend the tour to a regional map with electorial district by importing a kml file that was also...

Dear Community, I am attempting to connect the shapes, which i have named "pc****" (standing for post code, followed by the first four letters/ numbers of the post code), to a range of values with an adjacent name of the linked shape file. The purpose is for the map to change colour based on...

There is a website that I got instructions on how to create a thematic map that allows the shapes in map I created change color based on certain range of values. I created 3 shapes on map. However as I run macro it gives me error below. Error message: Run Time error '1004' Method 'Range' of...

Here's my excel Europe map and there is some province that will named(and showed in map). And I have a problem, I want to hide those words when I zoom out, and it show name when I zoom in the map. Any way to do this?