2010

Hi All, I've been trying incessantly to get a VBA to format all my charts to one size. I'm doing a range of charts, and I need them all to be 2.5" by 4.6". I've set up the code below and most times it seems to work, but other times it'll spit out weird measurements - 2.52, 4.63, 4.61, 2.51. It's...

Hello, I recently upgraded from Excel 2010 to 2013 and am having an issue with pasting. Basically, I have spreadsheet with multiple cascading (+) line items (see link below). the additional cascading line items breakdown data by date: Image 1: Imgur With 2010, I was able to select the rows I...

I'm attempting to create a worksheet that could act as a test prep. I have the questions in column B in cells 2 to 400 with corresponding 4 multiple choice answers in C2 to F400 and the and the answers in the corresponding rows in column H. My goal would be to have people able to click on the...

Windows 7 Microsoft Office 2010 I have the following formula that is not working: =SUMIF(LEDGER!H:H,BILLS,LEDGER!B:F) The formula is being used in a sheet titled "BUDGET" to get information from another sheet within the same document titled "LEDGER". I want it to searched through the H column...

Greetings, I am new to the forum so please pardon me if a thread like this already exists. I'm tight on time so I haven't searched very hard to find the answer to my question. I'm working on a monthly top 5 product chart for a project that is based on a monthly excel sheet of data. I have a...

Hello Mr. Excel, I'm new to the forum and a relative VBA novice. I have automated the production and export to .png file of multiple bubble charts based on a dynamic SharePoint list. These charts can then be lifted into Access to overcome the problem with the dated chart engine. My issue...

Hello everybody, I'm too limited to realize my macro, i need some tracks to follow :-) I have one file, with 14 worksheets. 12 worksheet of for monthly data entry, with details of movement for each location. (e.g: sheet March) Location 1 Location 2...

Hi, I think it's my maths skills (limited!) that are holding me up on solving this one... I am trying to write a formula to help me round up/down to the nearest whole number that is divisible by 3. My original numbers are already rounded up/down to 2 decimal points. I am using Excel 2010...

Hi I have a workbook with a lot of pivot tables. The workbook is also connected to an external database. Whenever I open the workbook, it automatically updates the data, but not the pivots. I know you can set the pivots up to refresh on opening, but it refreshes the pivots before it updates the...

I have an item list in a table of about 100 items and their prices I want to print. Item name | Price a a1 b b1 c c1 d d1 With so many items it becomes very long and hard to look at . How do I make it so the table stops at...

I have the following line in my VBA code in Excel 2010 rnl_fname = Application.GetOpenFilenam<wbr>e(Title:="<wbr>Select R560 Renewal SUM", _ filefilter:="R560Combined?<wbr>??.SUM...

Hello All I've developed an application in Excel 2010 32bit. It has 20+ spreadsheets containing data and equations, and I've created userforms to enter the data for those spreadsheets. These userforms consist primarily of text boxes. You enter the data in the text box and then click a command...

I have a bank of user defined functions (UDF's) which I keep in the personal.xlsb workbook. I used to run Excel 2003, and the same functions worked fine both in the personal.xlsb and main worksheets. In Excel 2010 I can use them in the personal.xlsb workbook when it is unhidden, but cannot do...

Hello all, I am currently working on a scheduling workbook for a few of our products, and need to link an image to our product numbers as they appear in the schedule. I have previously referenced this thread http://www.excelforum.com/excel-gene...combo-box.html, and was able to get the...

Sheet in 2010 won't accept Accounting format. But it's not locked and not protected against formatting. Data appears left flush with no symbols. When new rows or columns are inserted, won't format these either. Other sheets in workbook are fine. Would appreciate any suggestions. :confused:

I'm creating a forecasting worksheet that pulls values from a separate sheet using an array. Starting out, the array was working fine. I was able to copy, paste, and drag it through the necessary cells easily; that is, until it suddenly stopped working. About halfway through my forecasting...

Hi I'm struggling to extract the last 1,2 or 3 digits from an IP address. the problem I have is that I have different length of IP address, so for example 10.1.93.145 145.10.5.16 145.168.192.1 I am trying to extract the numbers after the last full stop so the above example results would be...

I have created a multi-sheet workbook for a friend. Occasionally he has entered data into cells with formulas and thus destroyed the logic. I want to show him the error of his ways by formatting all cells with formulas in a distinctive way. I have already provided his workbook with a UDF that...

I am creating a summary sheet for all the worksheets in a workbook. For example, I want to be able to sum E3 from all worksheets. I have been using something like: =Sum('*'!E3). This works fine, but each week I am adding a new worksheet to the workbook and the formula does not update with the...

Hello, I am using Excel 2010 and I am currently trying to find the Avg Min / Avg Max costs for 4 different groups.. Players, Accompanying, Coaches, Medical. I need it to get the minimum values from 3 different sections ( I am using custom names for them such as PlayerReg for Player...