excel 2007

  1. S

    userform calendar in excel 2013

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

    Getting Data from two sheets.

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

    How to sum cells that contain a value returned by the cell formula, and not sum the formula!

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

    Conditional formating using H:MM

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

    Return a value based on multiple variables

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

    Add multiple series to a dynamic chart from the same data table

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

    How do I only allow a whole number between 2014-2050 in an input box?

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

    Activex Controls not Working in Excel 2007 and Excel 2003

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

    Line Graph Chart Help remove zero from proceeding months.

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

    Evaluate a variable string, return part of it to a new cell - vba or inherent fx? excel 2007

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

    Consolidating data via formula

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

    Excel 2007 Problem

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

    Creating report in VB6

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

    Check value of several cells in one row, trying to shorten If Then statement

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

    Assigned data series color changes automatically

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

    Index/Match Formula question

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

    Macro to check if A#:F# on Sheet1 exists in another sheet, if not add to sheet

    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)...
  18. L

    VBA: copy unique-value's rows to a template in loop

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

    Scrolling Excel Stacked chart

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

    Need macro to copy & update data from 8 workbooks to a single workbook, without duplication

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top