state

Hi all, I have a the below pivot table. I have a formula which produces true and false. For this particular month in State 1, True is 0 where False is 4. So i want to show a percentage for a report I have to do, which gets updated every month. I only want to show the percentage of true against...

My question for the board is, does VBA coding offer a bettermeans of capturing data and performing calculations such as averaging based acrossmultiple worksheets? I have created aspreadsheet that records scores of tasks performed by task type and state over19 weeks (one worksheet per week). In...

Hi, I have my workbook set up to show a separate worksheet for each state. The representative from each state will go into their own state worksheet and select their state from a drop down list. When the state is selected, I need to bring in top 5 past due invoices for that state - data set...

I have created a Userform, which is working fine, Wills for Safe Keeping and decided to add some additional functionality. I would like for the County, City and State fields to populate when the Zip Code is entered. I have created a separate workbook to get this feature to work, which it is...

I have a list of states and their counties. I'm looking for a method to choose a state from a dropdown and a column of their associated counties appears. Or, if the user types in the 2 letter state name and it auto populates the counties. I've played around with dropdowns and v/h lookups with...

Hi forum, any help on this, including approaches I haven't considered, would be helpful. I scrape several websites to get raw data on foreclosure sales. One such website has changed their formatting and royally hampered my data gathering efforts. My starting sheet contains these data points...

Hi - I have a workbook with 51 tabs, 50 named after a state and 1 other. I have a drop down with each of the states on sheet1. How do i use the values in that drop down to reference one of the worksheets? Each of the state sheets would be the same, they would just have different data. I have...

I am looking for sample statistical data for a school project for creating a 3D Map using Excel's 2016 feature. I have research multiple websites, for example, crime in 2018 in the US. To create the 3D Map it requires the state, or country in the data in order to map it. Can you recommend...

I have see the answer to this here, but cannot find it now that I need it. I need to take a very large spreadsheet and make separate tabs in the same spreadsheet based, in this case, on a combination the county and state columns. (each County/State will have a separate tab in the...

A B C D E F G J JAMES 242 6TH ROSEBURG OR 97471 I have a mailing list that is in Excel where each column has the full name, the street address, and the next column C has the city and state in one column. But for my label program I need...

Hey excel gurus, I would need your help on running a specific code when key state is up. I am already aware of a OnKey method but that is not what I require. Another way of achieving this would be to use AutoHotKey. With a hotkey assigned to the excel macro that gets triggered on key up state...

Hi Is there a way tocapture the array in AA26:AH43 and then put the values abck to the sheet at theend of the sub I have a routinethat triggers a Stats App (BERT) by changing Go to 1 and then back to 0 I want to capturethe array within the trigger state But I want to avoidthe paste values...

Hi all, I'm a bit new to running data analysis in Excel, have a decent statistical understanding but not with regards to Excel. I figured out how to get the data analysis tools but am having trouble getting my exact setup for my data. The data I'm trying to build off of is this: I want to...

Hey there! I'm looking to migrate one of my 2D map charts into the new(ish) 3D Maps. It's a veeeeery standard territory map of the USA, so I'm using the Region type map. Now, here's the odd part: while you can enable "Map Labels" (main toolbar on the Home ribbon), that only adds the Bing maps...

Hello, I have a bunch of addresses where I need to extract state name to a new cell. The addresses look the following way: <colgroup><col></colgroup><tbody> 843 E Main Ste 203, Medford, Oregon 97504-7137 </tbody> <colgroup><col></colgroup><tbody> 7648 Victory Blvd, Newport, Arkansas 72112...

So I have a Geographic Heat Map with Textboxes for all 50 states and 1 for DC. I need to see about adding to the following code to make the Textbox backcolor/fillcolor equal the state color. Sub Paint() Dim i As Integer For i = 1 To 50 'First, paint the state shapes...

Hi I need a formula to look up maximum date and corresponding state In below case it should look at state , eg VIC and also maximum date 04/01/2019, giving answer 50 <colgroup><col width="64" style="width: 48pt;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt...

Hey all, I am wondering if it is possible for a macro to be called upon when a key state is Up. It can be done in a user Form but I would like to achieve that in a sheet without any userform. But if a value is being entered in a cell and/or the formula bar is in active mode, then bypass/avoid...

Hi, I need assistance to create a formula that will populate the state columns (F - H) with the Balance in Column D by checking: 1. The subacct in the workpaper tab against the data in the Subacct tab. 2. The Subacct tab will have the State associated with the subacct. For the 50000 in...

I have city and state in a column but need to add a comma after city and before state.