excel 2007

hello again, I have below questions with which I need help/suggestions please. 1. A userform created in excel 2007 which has calendar control option in additional controls - will this work as it is if system having 2013 on it? 2. How do I get Calendar control in 2013? If not, the code? 3. I...

Hello Guys! Can you help me in solving this excel problem? I have a data in one sheet and I need to reference this data into another sheet. Sheet 1 <tbody> Weight per shipment 5.1960 Zone 6 Cost $-------- </tbody> Sheet 2 <tbody> Weight Zone1 Zone2 Zone3 Zone4 Zone5 Zone6 4 $0.1...

Ok, i hope i can articulate this properly... I have built a fantasy football team selector in excel. The sheet i am having trouble with works by using a drop down list to select a player. Once selected that player will then pull data from the master sheet and display it in other columns. e.g...

Hi there! I'm working on a spreadsheet (using excel 2007) and I want to apply a conditional formatting rule that will change the cell colour if the H:MM is greater than 5:59. Because I'm going to be dumping info into the spreadsheet every day from another spreadsheet so I don't want to have...

I'm working on a spreadsheet and I want to return a specific value based on different variables. In column D the user can select from two different values (Simp or Audit), then in column H they can select one of 3 values (Val1, Val2 or Val3). Based on what is selected in these 2 columns I want...

I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. Each column of the table has its own named range which allows this to work and for the charts to...

I have some VBA code that asks the user to input the year of the report in the format of YYYY. How do I restrict the code so that the user can only input a year between 2014-2050? For example, I do not want the user to type in 15 for the year 2015. Here is the code I have so far: 'Ask user...

Hello, Since the last few days, I am unable to use Activex controls in Excel 2003 and Excel 2007 on my system, which is also the case with my colleagues. I can't insert objects either as it gives me "Cannot insert object." error. This is working fine in Excel 2010. Below is what I've already...

Hi All, I have a graph line chart. Broken down by Month (Jan-Dec on the horizontal track) tracking sales for this year and last year. I hate the way the graph looks because since I only have sales from Jan to Jun only the other months are showing zero and the bar graph is showing the zeroes...

Hi there.. I have a column which contains notes exported from a database. The notes are formatted with pipes as delimiters, there maybe 5-10 notes (delimited strings) in each cell of Col N. Each string will also contact a timestamp and the person's name who wrote the note, and the pipes appear...

Hello all, I am working on creating a data reduction sheet for a very large amount of data acquired through a Data Acquisition System. I have a 'Raw Data' sheet set up to quickly copy and paste over the entire DAQ file into specific columns. One thing I am recording is the flow rate through...

Sub coveractive() Dim cover As Worksheet Dim wb As Workbook Set cover = ThisWorkbook.Sheets("Cover") cover.Activate End Sub Private Sub handletemp() Dim wb As Workbook Set wb = Workbooks("Workbook.xlsm") Dim ws As Worksheet Set ws = wb.Sheets("Temporary...

I develop an application in VB6 and my data source is Excel 2007. Now, I try to create DataReport. I could connect the excel file to VB. When I click the “Test connection” button in the Data Link Properties I receive the message “Test Connection Succeeded”. To fetch and put the data in the...

I'm trying to have my macro check if cells in a row on two different sheets match. I'm able to get it to work using And & Offset, but I'd like to know if there's another method to accomplish the same thing in a shorter code. This is essentially what I've got so far: Dim Sheet1 as Worksheet...

Hi, I have a bar chart with 9 labels and i want to assign colors for each label. But every time i do that, it changes to the default colors assigned by excel in that particular order. I tried creating a custom theme but you can choose to only upto 6 colors. I clicked on the format series tab...

I'm using an index match formula where the index is a named table called "UnemploymentTable" on another worksheet within my Excel workbook (see screen shots below). The trouble I'm having is when I drag my formula to the right, the index/match formula is going to my table and looking up one...

Going to try to make this as brief and simple as possible. My workbook has 3 worksheets, each sheet's data starts at A4, columns are A:F. I'm trying to make my macro read Sheet1!A4:F4 as a single value, then check if it exists in either Sheet2 or Sheet3 (also A:F, not in a single cell)...

Hey guys! I have this recurrent situation at work which I think could be fully automated by a macro, however, being a total newbie, I'm not able to do it by myself. Many thanks in advance for any help given =) Every week I get a big report which lists the clients of each of our sales people...

I have two stacked bar graphs which are adjacent to each other horizontally on the same worksheet. Below these graphs I have represented the data is a tabular format. The data in concern is sales numbers for 6 sectors on a weekly basis. The first graph and the table below it has data as per a...

As part of an office task organization to keep track of our progress with prospects, we're trying to create a spreadsheet that we can update as needed. This is related to a previous thread I had started, relating to a macro which will sort entries (rows) into other sheets in the workbook...