excel2010

ok i am doing a final exam spreed sheet for my school and i need to use an If statement with the data validation function (drop down list) here's what i got so far =IF(L2="poor",1*L15,""=IF(L2="Normal",L15*2,=if(L2="Awsome", L15*3,0))) where as "poor", "Normal", "Awsome" are the option in...

Hi, I'm seeking to run some VBA code in Excel 2010 on a Windows XP machine. The goal of the code is to take a large Excel file and break it down into a set of distinct files (e.g. Report_Department100, Report_Department200, Report_Department300) which will then be examined and emailed out to...

Hi. This is my first post. Excel 2010. Spreadsheet with VBA was written in an older version of Excel (2003, I think). On my machine, the spreadsheet works fine. I'm on Windows 7. On a Vista machine, when we open the spreadsheet we get the subject error. I have Googled, and checked that VBA is...

Hi, Hoping someone can help with the following. I am reading the book "Pivot Table Data Crunching 2010" chapter 10 "Mashing Up Data with PowerPivot" page 216, section "Using RELATED() to Base a Column Calculation on Another Table" As per the book the sample file is called...

Hi, This problem seems stupid but I really in trouble and need your help. Currently, I used Windows 7 with Microsoft Excel 2010 in Lenovo Thinkpad laptop. I notice that I cannot use an Excel keyboard shortcut to add row, delete row and other shortcut i.e. remove border Normally, I used...

Hello folks! Can hyperlinks be converted to buttons please? I've a large number of links so a global conversion is what I'm hoping for. Thanks muchly.... Max :) P.S. I'm running Excel 2010