Problem in opening an Excel 13 Macro Enabled Workbook in Excel 10
I have designed a Macro Enabled workbook in Excel 13. The workbook contains Userforms, Commandbuttons, Checkboxes and other macro functionalities. These are …
Create multi-select drop-down based on another multi-select drop down
I am hoping someone can help me. I have a multi-select drop-down in one of my columns in excel. The user can select and de-select values from a list of 12 …
Excel add total of entries separated by a + sign in a formula?
I’d like cell E433 to total the amount of entries entered into a formula in cell F433 where the formula is: =91.72+38+292.45+38.4+81.23+43.52. …
Deleting excess rows in a table when copying over information
At my job I work with large amounts of data. I have an Excel spreadsheets with tables that contain all of my necessary formulas and fuctions, but I frequently …
Excel 2010 ‘IF’ Formula trouble
In my highlighted cell I want to say:- If K25 has the letter G in and M25 has the letter G in and O25 has the letter G in then my highlighted cell would be G. …
Automatically update data in two different sheets?
Hi everyone! Since yesterday, I got stuck with a problem, and surfed the entire www, looking for an answer, but no succes. Long story short, I have …
Consultant
I am using Excel 2010 on a Win7 PC. I created a pivot table based on a fairly small data set, combination of text, formulas, percentages, numbers, …