Stack Overflow
Stack Overflow

Questions tagged [excel-2011]

Excel 2011 refers to the spreadsheet editor included in Microsoft Office for Mac 2011.

151 questions
0
votes
2 answers

Excel: How to duplicate without some specified cells?

So basically, I want to create a hyperlink on one of my worksheets that allows me to duplicate it exactly, without a few cells. I found this on the Microsoft Support website that allows a worksheet to do duplicated exactly: Sub Copier1() …
Fizzix
  • 23,679
  • 38
  • 110
  • 176
0
votes
2 answers

debugging issue when trying to look through a column

Dim Brand As String, Status As String, CaseNumber As String, CaseSummary As String Worksheets("1st").Select Brand = Range("B25", Range("B25").End(xlDown)) I am trying to run a macros where when I click on a command button, it will insert…
BruceyBandit
  • 3,978
  • 19
  • 72
  • 144
0
votes
1 answer

How to keep numbers on x-axis in graph

I have recently made a bar graph in microsoft excel 2011 and want to label the bottom x-axis values as 'Optimization Level' with numbers corresponding to each bar. When I click the 'select data source' menu and then insert the word 'Optimization…
cjavier70
  • 483
  • 1
  • 4
  • 14
0
votes
1 answer

Adding calculated field from VBA in an Excel 2011 macro to a pivot table in an Excel 2003 book

I have a macro running in an Excel 2011 workbook that is manipulating a pivot table in an Excel 2003 book. So far I haven't add issues with adding or hiding fields. I'm trying to add a calculated field (as here -…
ryantkelly
  • 93
  • 1
  • 9
0
votes
2 answers

How to build non-consecutive ranges of rows based on cell contents?

I'm just getting started with VBA for Excel. I used VB and Java in college nearly ten years ago and was competent with it then, but am essentially starting over. (Um, not like riding a bike.) I am trying to understand the methods to build a range…
user2601892
  • 23
  • 2
  • 7
0
votes
1 answer

Use cell value as part of a reference to a cell range in a formula

My problem is similar to that in this quesion: Row in formula change based on value in another cell, i.e. I want to use the value of a cell as reference to another cell in a formula of yet another cell. However, I want the value of a cell to only be…
msallge
  • 107
  • 1
  • 10
0
votes
1 answer

Compare Data from 2 Worksheets in Excel 2011

I have an excel workbook with 2 sheets of alphabetical business listings, one from this year and the other from last year. The 2012 listings have categories assigned to them, the 2013 ones don't. I want to copy the categories from the 2012 listings…
jbwharris
  • 710
  • 1
  • 10
  • 30
0
votes
3 answers

column shading by date range

I have a spreadsheet that has various rows filled in colours while the columns are set to months in text form - 'mmm' what I want to do is format the sheet so the column that is the current month is shaded - for example - March - to show it is the…
user1086159
  • 1,045
  • 5
  • 16
  • 24
0
votes
1 answer

Selecting cells that have been Formated with Conditional Formatting

I'm looking for a way to copy a series of cells that have been Conditional Formatted. We have a spreadsheet with cells that we have tagged as "TBD". I created a rule to formate every Row that has "TBD" anywhere in it, which is what we want. Now I'm…
chrisgruggen
  • 3
  • 1
0
votes
2 answers

What are macid filetypes in excel vba

What are all the possible MacID("filetype") I need the one specifically for CSV but i couldn't find a list anywhere online surprisingly.
Drfrink
  • 404
  • 1
  • 9
  • 25
0
votes
1 answer

VBA - Search and remove duplicates

I'm looking for an algorithm for which I do not have the VBA knowledge to script myself. So I'm stuck. It isn't through lack of effort trying because I have given it a go (plus, this bit of code is the last remaining piece of my bigger VBA code) I…
qwerty_face
  • 201
  • 2
  • 4
  • 11
-1
votes
1 answer

Excel SUMIFS of cells based upon multiple criteria

I'm trying to create a formula which calculates the sum an array of fields based upon multiple criteria. This relates to various franchises and the promotions which they run during the year My document contains two sheets with the following…
Forster
  • 3
  • 3
-1
votes
2 answers

Count rows where value exists in Column A and other value exists in Column B

I am using VBA in Excel 2011 (but saving to Excel 97 - 2004) to count all matching values in column C where the value is training. To do this I am using the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If…
jack harper
  • 1
  • 1
-1
votes
1 answer

Mac Excel 2011 - Excel Web Query - Loops and Selections

I am using Excel 2011 to execute the following query: WEB 1 http://careers.accel.com/careers_home.php?p=1 Selection=EntirePage Formatting=All PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False I was…
Nick
  • 93
  • 9
-1
votes
1 answer

Auto Generate Excel Table Using VBA

I should preface this question by stating that I have 0 experience using any of the advanced features of Excel, and now that I need to use them, I have no idea what I am doing. I need to generate an excel table with the following columns: ID,…
Wingdom
  • 439
  • 2
  • 10
  • 23
1 2 3
…
10
11