Excel Table Appears to Automatically Expand but drop down list doesn't update
I used Excel 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 insert a row of data at the very top or bottom of the list (range), even though the table appears to have expanded, the drop-down list does not update automatically. 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.
Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.
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.
