Questions tagged [excel-2013]

The Excel-2013 tag is used for referencing the Excel Version 2013 spreadsheet application from Microsoft. If your question is about VBA then also tag it VBA. If it is about an Excel formula then tag it Excel-Formula.

Excel 2013 is the 15th version of Microsoft's commercial spreadsheet program. Microsoft has significantly enhanced the charting and Business Intelligence capabilities in this new release.

This tag is used for questions specific to the 2013 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 . Questions about addins for Excel 2013 should be tagged .

Links:

1745 questions
0
votes
2 answers

Macro to resize textboxes to fit exactly on the cell its sitting on

I am using Excel 2013 and have created some macros and am currently embedding them into textboxes. How would I make a macro that takes selected textboxes and centers them and sizes them to fit exactly on the cell that they are sitting on. Sub…
Michael Downey
  • 687
  • 3
  • 13
  • 42
0
votes
1 answer

Macro to Paste Range Names

So far I have this. Sub Macro1() ' ' Macro1 Macro ' ' Range("E3").Select ActiveWorkbook.Names.Add Name:="CGSF.COMUTIL.2", RefersToR1C1:= _ "=Sheet2!R3C5" ActiveWorkbook.Names("CGSF.COMUTIL.2").Comment = "" …
Michael Downey
  • 687
  • 3
  • 13
  • 42
0
votes
3 answers

Concatenate data frame to list

I have a some row names in Excel with their respective publications. Name Pub AAAA MNWP AAAA TIWD BBBB CGWK BBBB MNWP CCCC EXWE CCCC EXWE CCCC HXWT CCCC MDWE CCCC MDWE CCCC MNWP CCCC MNWP CCCC NDWK…
phg
  • 536
  • 1
  • 7
  • 19
0
votes
1 answer

Data to Excel Composite Line Chart

I am having some difficulty in populating a data into a composite line chart I have the following data weekday(sunday,monday,tuesday...saturday)*hours(0,1,2,3...23)*minutes(0/30) day hour minutes unique_counts sunday 0 0 922 sunday …
Logan
  • 1,331
  • 3
  • 18
  • 41
0
votes
1 answer

if-statement in a for-loop with a counter

I have the following situation I can't figure it out. Is there a way to get a counter in a if loop without overwriting itself. I have this code: lastrow = Sheets("sheetx").Cells.SpecialCells(xlCellTypeLastCell).Row For a = 1 To lastrow If…
Tarik
  • 77
  • 1
  • 1
  • 11
0
votes
1 answer

replacement for a if statement or the use of a collection

Earlier I asked a question where I couldn't get a correct answer. I think I couldn't express myself properly. This is a problem I am facing: Sub organize() Dim GroupID(1 To 30) As String Dim GroupAanwezig As Long Dim class As String …
Tarik
  • 77
  • 1
  • 1
  • 11
0
votes
1 answer

redefining an integer vba

I have difficulty fixing the following problem I am facing: Lets say I have this code i_GroupNumberA = Application.WorksheetFunction.CountIf(Sheets("SheetX").Range("G2:G500"), "Red") i_GroupNumberB =…
Tarik
  • 77
  • 1
  • 1
  • 11
0
votes
1 answer

Create a button to toggle between Fahrenheit and Celsius

I have a spreadsheet with yearly temperatures and other weather data for a specific area and I am trying to figure out how to create a macro assigned to a button that changes all the temperatures from Fahrenheit to Celsius and vice versa.
jsmitty82
  • 13
  • 1
0
votes
1 answer

Excel formulas bogging down

I am trying to use a grouping column in my excel sheet but the code I am using is extremely unwieldy and is beginning to bog down my spreadsheet when I view it, sometimes crashing…
L.P.
  • 83
  • 8
0
votes
0 answers

Excel 2013 CSV parse algorithm bug?

It seems that Excel (I've tested 2013 version) parses malformed CSV files without errors/warnings. I've created my own lib for parsing CSV files. Made a sample CSV file for test (semicolon is the delimiter): TEST_STRING;Field1 "Band "Radiohead" in…
Burst
  • 689
  • 7
  • 15
0
votes
1 answer

Expand a data set using two columns

In Excel, I have two columns of data that I wish to combine. Current set of data: +---------+---------+ | column1 | column2 | +---------+---------+ | a | 1 | | b | 2 | | c | 3 | | d | 4 | | |…
0
votes
1 answer

Excel 2013 | Trying to move from bottom of list in one column to top of next column

I'm trying to fill in a list in a block of cells: D2:E8 moving down. When I get to D8, I want to be able to hit enter (numeric or regular) and move to E2 to start the second column of the list. I realize I can tab, enter, tab, enter..., but, I…
0
votes
1 answer

Filter, copy and paste special in new Excel worksheet

I want to use VBS in all worksheets of an Excel document which will do the following actions: Filter the table Copy filtered content Create new worksheet Paste Special values only and save as csv file I try to achieve this with this code but it…
vladiz
  • 174
  • 1
  • 3
  • 14
0
votes
1 answer

excel drop down grabbing info from another sheet

I'm trying to create a drop down list that has the names of the other sheets in my workbook. When I select one of those names from the drop down I would like it to grab all the people's names from that sheet and display onto the sheet with the drop…
0
votes
1 answer

Cross reference 2 columns in Excel with another 2 columns

So I have a question about cross referencing. In Column A and B I have the original Data, and I want to cross reference it with Column D and E. Now Column D and E is a for places that have more than 10000 Visitors per month, and I want to find out…
user3784616
  • 1,939
  • 3
  • 15
  • 10
1 2 3
99
100