Excel Table Appears to Automatically Expand but drop down list doesn't update
I usedExcel 2013. I created a drop-down list that is based on an Excel Table via the Data Validation button on the Data ribbon. If I add or delete a row from the middle of the table, my associated drop-downs are updated automatically. However, if I inserta rowof dataat the very top or bottomof thelist (range), even though the table appears to have expanded,the drop-down list does not updateautomatically. The Auto Correct options "Include new rows and columns in table" and "Fill formulas in tables to create calculated columns" are checked.None of the sheets on my workbook are protected.
Formula or function for IF statement based on cell color
I don't know how to code in VBA but am trying to automate an if/then calculation based on cell color. As shown in the picture, if the colors of the cells in column B are the same as those in Column G across the row, I want to subtract the values in columns F and K in the same row to return the absolute value of the subtraction in column L. If the colors of the cells are different, I want to add the values in columns F and K and return the value in column L. I will have multiple tables of varying numbers of rows where I need to perform this operation. Any help is greatly appreciated.
VBA Macro and wookbook transfer
I created multiple Macros and a detailed workbook on my personal computer and I now need to move them to another computer. I transferred the XLSTART but I am getting errors, I can't modify the code on the new computer. Can someone help with the process. I am not sure if I got the right XLSTART object.
Trouble loading JSON to Excel
I have a JSON file that I would like to import into Excel I have Office 365 I am using the following: Use Excel's Get & Transform (Power Query) experience to connect to a JSON file. Click the Data tab, then Get Data > From File > From JSON. Browse to your JSON file location, select it, and click Open. Once the Query Editor has loaded your data, click Convert > Into Table, then Close & Load. I only receive two rows in my excel spreadsheet but there is quite a bit of data. Help appreciated. -JPcalculating water rates on a per thousand/tier
I am trying to calculate a water table that I could change the rates in B12-B23 in order to get a monthly bill about for water consumption. I have found several issues. Even if 0 qty is used there still is a charge of 7.50 I need to know what to put in the formula to have 7.50 put in even if 0 qty of water is used. Qtys 0-3 do not have a monthly 7.50 charge so all other amounts above that need to have 7.50 added to the bill. I need my equation to charge the monthly fee if applicable, and the cost per thousand. example in B13 the qty used was 2 (2000 gallons of water) that water is charged at 7.50 flat. Because 0-3 qty has a flat rate of 7.50. But on B14 the formula should show that the customer is being billed 7.50 for the 1st 3k gallons of water, and then needs to be billed 3.19 for the extra thousand gallons of water. Each thousand gallons of water used needs to be billed based on the water sales. Does this make sense? attached is my spread sheet. Please HELP!!Pop Up Calendar
I followed this tutorial http://www.fontstuff.com/vba/vbatut07.htmand made a nice pop up calendar to use. But it only opens if you right click and click on insert date, or you can pull it up with a keyboard shortcut that they had me write into the code. My question is, how can I get it to pop up byclicking in cells I want dates in? I don't want to have to do it manually. I don't know how to write code but I can follow instructions.
