2007

  1. B

    Using vba excel to find triplets with an exact difference

    HI5 folks, i wish to find triplets of numbers with the difference of 11 within each row/line in the excel spreedsheet. three any numbers (x,y,z) whose difference is 11 , in other words z-y=11 , y-x=11. I use excel 2007. I tried it by using this code below: Sub FIND1()...
  2. W

    Mortgage game calculator

    Here I have 3 pictures of a worksheet I'd like to create. The worksheet is on house mortgages I'm supposedly buying. I want to be able to delete them and put them in and have the ease of starting each one by buying and selling property at different months in the year period. Month 1: Imgur...
  3. E

    Series Titles (Legends) on pivot chart won't update after edit

    Have a pivot chart with some series titles in the legend that I want to change. I click on the series, go to Analyze in the Pivot Chart tools, go into the Active Field and edit the name. One series works just fine, but the other one won't keep the edited name. It just reverts to the original...
  4. S

    Excel 2007 Save As PDF Macro

    Hi I recently created a macro in Office 365 to save as a PDF, here's the code: But it doesn't seem to work in Excel 2007. Please help.
  5. andrewb90

    Verify excel Version upon opening or closing

    Hello all, Is there any way to add something to my opening or closing code that would check what version of excel is being used? I have a number of features that won't work with Excel 2003 or below, and they are critical features, so I just don't want the workbook to be used in Excel that's...
  6. R

    Macro / VBA to validate cells and write errors to a seperate errors sheet

    Hi, I'm trying to create a macro that runs loads of validations on a data sheet/template we receive. (there are a lot more than is currently in my code below) When it finds an issue the macro formats the fill of the cell to red and then it needs to write the issue to an error report in a new...
  7. B

    Headers won't update in 2007 Excel workbook

    I have a workbook created w Excel 2007, has about 50 sheets, half of which are charts based on the data in the other sheets. Every time I update the data, I need to change the sheet headers. The headers are all the same: "Quarterly Monitor Through month, day" All I need to do is change that...
  8. L

    Code Review Request

    Good Morning/Afternoon All This is my first post, My name is Jorge, but call me George, I work as a Controls Engineer at an Automotive Parts Supplier in Mexico. Straight to the point. I have a heavily scripted Excel File that serves as a Database for a client, i would like to ask somebody...
  9. B

    Problem printing multiple sheets to one PDF file

    Using Excel 2007 in Windows 10, but had the same problem in Vista. Have a workbook with about 50 sheets, half are data sheets, half are charts based on the data. To print only the charts, I hide all data sheets, right-click on a chart sheet and select all sheets. In print preview, I see 68...
  10. G

    Excel compatibility issue 2013 vs 2007

    I have a file that has been sent to me by a third party that was created in Excel 2013. I have 2007 as our standard issue at work. The file has been sent to me in both xlsx and xlsm form. In both cases, the file opens fine in 2007 but in the case of 3 tabs only, just the act of selecting any...
  11. D

    Excel 365 Pro-Plus performance issues

    Excel Performance Issues Microsoft Excel regularly crashes when working in large workbooks(although this appears to happen in normal sized workbooks) with the Error Message: 'There isn't enough memory to complete this action. Try using less data or closing other applications. To increase memory...
  12. D

    Upgrading from Office 2007 to 365 (Pro-Plus) Excel - disconnected sources

    My company is currently upgrading from excel 2007 to 365 Pro-Plus(current version 2013) and we are running into quite a few issues regarding lookups and linked spreadsheets. Excel Spreadsheet refreshing data from disconnected sources Users regularly email spreadsheets that use external data...
  13. T

    Conditional Formatting

    Hi All, Please help me about conditional formatting, suppose I will type an exact word or value "TEST" in cell B2. Is there a way after typing the word "TEST" in cell B2 the cells from A2 to F2 will change to my desired fill color? I know there's a way out here please help. I am using MS...
  14. S

    Excel 2007 (I know) Conditional Formating

    I still have 2007 and am trying to use a formula to pull a match from another worksheet but 2007 will not allow "AnotherWorksheet!" Is there way like Vlookup or Match that I can use to look at worksheet 2 for a match and if so highlight cell in worksheet 1? Thanks, Steve
  15. R

    formula to get the answer in the table

    Hi guys! I badly need you help, I'm trying to put some IF statement to get answer but its TOO MANY "If" statement. I wonder if there is a way to get the answer, To get the answer you must consider the 3 factors. WORK HOURS, CLOCK TIME(1:00 to 11:00 for the 1st shift and 12:00 to 0:00(or...
  16. J

    Disperse Data from Single Excel 2007 Workbook to Multiple Workbooks

    Hi all, Just looking for some macro/developer help for Excel 2007. Basically, I have one database workbook, and I want to disperse the data to various other workbooks as efficiently as possible. I’ve searched for an answer but all I can seem to find is "How to merge data from multiple Excel...
  17. InaCell

    2007 image on chart problem

    Hi I'm using Excel 2007. I have a simulated vehicle dashboard in a chart that uses telemetry data to operate a tachometer and speedometer. I put a logo image onto the chart dial face for asthetics. Now I can't see the needle at all positions as the image covers it. I have tried making...
  18. A

    MS Query, Join 2 data sources using partial match

    (Excel 2007) I've been trying to track down the exact way to do this, and I just can't seem to get it. So stop me if I'm doing this all wrong. I have a ODBC data source which consists of a lot of manufacturing BOMs (Bill of Materials), now a customer wants us to make a list of all their boms by...
  19. M

    Order Template with vba to select distinct values and then loop through on those values in XL2007

    <colgroup><col width="69"><col span="7" width="64"><col width="71"><col width="85"></colgroup><tbody> </tbody> Hi I am hoping to learn how to setup a unique list of vendors (VendorList) from a list using a named range, then loop through that list in a VBA macro that is using filters...
  20. S

    vba 2007 sharepoint 2007 - update sharepoint list

    Hi - I have been attempting to update a sharepoint list using vba 2007. I have attempted the following: using SQL to treat the list like a database table (using connection strings - per SharePoint connection strings - ConnectionStrings.com). With this method I can write to an Access database...

Some videos you may like

This Week's Hot Topics

Top