Stack Overflow
Stack Overflow

Questions tagged [excel-2010]

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft. If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.

Excel 2010 is the 14th version of Microsoft's commercial spreadsheet program. Microsoft made slight user interface (UI) changes; otherwise, it continues to use the UI pioneered in Office 2007.

Features such as Sparklines and Slicers were introduced in Excel 2010 to provide more charting and data visualization power.

This tag is used for questions specific to the 2010 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it or . Questions about addins for Excel 2010 should be tagged .

Links:

6168 questions
1
vote
3 answers

Excel - Use INDEX() For Greater Than Values?

My current spreadsheet looks like this: Unit Cost: one-off cost of an individual item. 1-6: cost multipliers based on volumes required. Volume: Number of items. Basic Cost: =( Unit Cost * Volume ) Reduced Cost: =( Unit Cost * Volume * Cost…
W.H
  • 187
  • 2
  • 4
  • 15
1
vote
1 answer

Merge Many excel files to one new file with different sheet

I am trying to merge many excel files (workbooks) from a folder. My problem is that I want to move different sheets to the new excel file. At the moment my code can only move one sheet at the time from these different files. Example: I have 3…
JessieQuick
  • 51
  • 8
1
vote
0 answers

Creating 1 stacked column in a graph of unstacked columns

Currently I have a bar chart that looks like this: The red column is a subset of the green column (meaning that the green column is red column + some other data), so I want excel to combine them into one stacked bar with 4/5ths of the column…
Evil Washing Machine
  • 1,293
  • 4
  • 18
  • 43
1
vote
1 answer

VBA code - Stuck at the 4th loop

I have a code that is supposed to open a website, select a location, copy the HTML table to the Excel sheet and repeat on another location. However when I tried running the 'For' loop, I got error at the 4th iteration. The message said "Object…
Leslie Heng
  • 13
  • 2
1
vote
2 answers

java.lang.ArrayIndexOutOfBoundsException reading from excel file

I am trying to read the following data from an Excel sheet With the following code import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; public String readUsernameFromExcel() { File src = new…
OhAye
  • 93
  • 1
  • 4
  • 12
1
vote
1 answer

Autonumbering format based on value other cell

I'm trying to make a worksheet where one column automatically numbers based on the value of another cell. If the cell in the first column says 'MSG', the value in the next cell, should be something like MSGRA15_00001, if in another row, the first…
Steve Noyelle
  • 13
  • 3
1
vote
1 answer

Copy non-contiguous columns into into a multi-dimension array?

I'm trying to copy values from one sheet to another, comparing the Key values (columns A & C) and either pasting a value (column E) into the target sheet or adding a row and pasting all three values into A, C, F. Here's a sample of the data: SOURCE…
MJA
  • 350
  • 1
  • 3
  • 15
1
vote
1 answer

Discontinuous Solver Constraint Workaround

I am developing a production simulation using OpenSolver in Excel. I know that I cannot use if, or, and statements to constrain a solver. I need a constraint that says: X has to be within the range of 150 - 250, or X can equal 0. I have read about…
tdanner1993
  • 19
  • 3
1
vote
1 answer

Dynamic chart data series referring to multiple named ranges

I have a chart in Excel 2010, and I want to have a data series that can refer to multiple named ranges based on criteria in another cell. For example, if A1 = 1, the data series will display the data from S_1, and if A1 = 2 it will display the data…
bakeson
  • 91
  • 1
  • 2
  • 9
1
vote
3 answers

Take out characters and put in a new column in Excel

Hi I'm a bit new to vba so I will try to explain my problem as far as possible. I have a dataset in Excel in Column A, I have a lot of file names like this: 1. AB000**1234**45.tif 2. AB000**1235**45.tif 3. AB000**1236**45.tif 4.…
JessieQuick
  • 51
  • 8
1
vote
1 answer

Excel - Hiding last picture in row of invoice

I have built an Invoice worksheet that has a top portion (A1:K19) that will remain static; this is the top portion of the invoice. Below Row 19 starts the individual item lines that will be populated with what items are ordered. I have created a…
Stackexplorer
  • 13
  • 6
1
vote
2 answers

VBA, Creating Formula to go down the bottom of a column with data

I'm extremely new at VBA, however using google and in particular stackoverflow I have developed some reasonable skills in VBA and managed to accomplish a lot in no more than two weeks. I'm trying to get VBA script to paste a formula down column A…
joshc
  • 13
  • 4
1
vote
1 answer

Creating Calculated Field with SUM and COUNT of Fields Pivot Table

Here's a snapshot of my pivot table. I want to create a calculated field that displays the percentage from the Responded column (C) over the Ticket # column (B) as in column G. The Ticket # column is a column of value text strings (e.g. 413456,…
Concerned_Citizen
  • 6,548
  • 18
  • 57
  • 75
1
vote
3 answers

Copying excel data from one sheet into another sheet

I've been searching for this on google but no luck. I have multiple sheets in my excel workbook, and one sheet as a 'summary' page. I want the data from the other sheets to update in my summary page. Whenever someone adds a row or adds new data I…
user3151956
  • 13
  • 3
1
vote
1 answer

Excel VBA - Evaluate MIN with two criteria not working

I am currently writing a piece of code, that finds the first date of something for two categories, in the cells. If one of the cells has a date filled in, it ignores it but if the other cell is blank it runs the evaluate formula. The problem I am…
atame
  • 521
  • 2
  • 12
  • 22
1 2 3
…
99
100