2013

Dear All, this is my first post and I hope I stick to the rules. I have the following problem. I have a pivot graph connected to a slicer with different company names. In a different flat Pivot table I list the companies by market share and I would now like to only select the first 4 Companies...

Hi, I am trying to create a simple solution to allow the contents of a drop-down data validation list (within a table) be determined by the value of a cell 2 columns to the left of the drop-down cell; a Name -> Job relationship. Workbook after the link >...

I am looking at someone's code and I can't figure out why this particular issue is happening. There is a Sample.xlsm document with four buttons that run four similar functions with slight variations. One of the function breaks Excel causing the complete top menu bar to disappear. It does not...

I'm trying to display the SelectNamesDialog with a subset of the Contacts to allow the user to pick one so that later I can pull all of that contacts information into Excel. First, I'm getting a list of contacts that have been marked as "Customers" via the contact field User1 Then I'm adding...

The following code loads a table for "Contact Types" (Customer, Vendor, Shipper, etc.) While trying to bulletproof the code I discovered that when the table is empty that this line generates an unexpected result: row_ContactType = .Range.Rows.Count - 1 'Do not count the header" The...

Hello, I was just recently upgraded from Office 2010 to 2013. I had several macros in 2010 that I used regularly that are no longer working. One of the reasons has been resolved -> it was having issues with date formats or recognizing dates even when manually typing them in. This was fixed...

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...

Objective: reference 3-digit number in column "D" on a row-by-row basis and assign a target price value based on condition Sub assignTargetPrice()' Dim x As Integer Dim targetPrice As Integer Dim i As Integer targetPrice = Cells(i, 186) x = Range("D2:D500").Select Do While Cells(i...

Hi all. I am struggling to create a basic line chart out of source data that is in a two-dimensional format. A sample will be easiest to understand: _____|COL_A__|COL_B___|COL_C___|COL_D ROW_1|_______|Jun-2013|Jul-2013|Aug-2013 ROW_2|Client1|12,502__|12,502__|12,502...

Hi all I'm quite new to VB and Excel and can't get something to work. I'm working on my fitness schedule, which consists of 16 weeks. On the first sheet (called "Main") I defined the numbers of reps and weights for each exercise per week. For each week of training I've made a sheet that uses...

I need to create a workbook, called “Roundup.xslm,” that links back to cells in the primary workbook, “Articles.xlsm.” Each record (row) has six columns (A:F). One of the columns is hyperlinked to a file or Web URL. I need to link the rows in Roundup to the records in Articles so that when the...

Hi Everyone, Using Excel 2013 (32bit) to build an add-in for my workplace. Done lots of this sort of thing before but new to Excel 2013. I have a userform with several controls on it, one of which is a TreeView. This TreeView control is used to display and interact with structured data from a...

Greetings, I have a sheet with 2000ish rows of data. I have formatted it into a table in excel 2013 and added a number of slicers which I'm enjoying. The issue is if I ever scroll down to view more of the data the slicers scroll out of view. I understand I can prevent the slicers from moving...

Hi all. Question 1: I have an Excel Workbook that I use to record Health Assessments for a number of different companies, listed in a separate sheet in the same workbook. For each company, I then have quite a big number of employees. These are listed in a separate Excel file (all employees of...

So I have a macro that works fine when I go to Developer tab > Macros > (select the macro) > Run. But then I assigned the macro to a button (I tried a rectangle shape first, then a form control button - both were the same), it gives me an error when I click the button. The error says "Cannot...

In Excel2013, I'm trying to generate a graph from this table. It turns out like this. This is almost what I need however there is an unnecessary whitespace for every blank cell. It's more obvious when you look at the ref bars. I suppose Excel is creating a column of height 0 for every...

I used to prepare dashboard in Excel 2007, just got 2013 and added one month's data into it, wherein I did not use any unique feature of Excel 13, this worked well on Laptop. Problem occurred after publishing it worldwide, my colleagues who have Excel 2007, they are getting following error...

I have come across a very interesting chart from Office Templates, however it seems too complex for me. All the data and working is there, it would be great if somebody would help me understand it, here is how the chart looks: The chart is made for Excel 2013, which I am also using. The...

Hi guys, First of all, I would like to thank the contributors on this forum for their immense help to me in the past. As to the question. I am using Office Pro 2013. I want to make a graph (inside Word preferably) that looks like this: Now unfortunately, I am able to do only one of two...

Hi all, New to posting on these forums, though been a regular viewer for a few months now. I have a rather basic question, or so I think, but struggling to find the answer anywhere! I want to create an excel doc at home (using excel 2013) which will be a test style doc, featuring option...