1. C

    sumifs formula

    =SUMIFS('VISTA DUMP'!A:A,A1,'VISTA DUMP'!G:G,"OPEN",'VISTA DUMP'!J:J) Hey guys cant get this formula right i am trying to make a sumifs formula to check if column A in sheet 1 appears in vista dump column A and contains "open" in vista column G it will add the corresponding numbers in vista...
  2. FuzzyTom

    Excel Macro Stopped Working

    Excel 2007 My excel macro suddenly stopped working on a Windows 8.1 professional. The macro starts and then just continues to run until I stop it. Even if I "run to cursor" in visual basic the macro seems to be doing nothing and will run until I stop it. This macro has been working for...
  3. N

    SendKeys on Vista

    hello forum, i've made an VBA tool that would take the printscreen of the previous active window and copy it into Excel using Sendkeys the program is running perfect on XP but fails big time on Vista. do you know if there is anything specific with Vista that would have an effect on the...
  4. T

    Counting only occurences of text item in a list that has a value entered against it in the same row

    MS Excel 2007, Vista, The task asks that I find the item of (in this case) second hand uniform that has sold most units. To do so I need to create a list of unique items (text) found in a column that list all individual items that are or have been in stock. (which I can do using Advanced...
  5. J

    Copy Files to A Compressed Folder

    I am trying to put several files into a zipped file (Windows Vista uses compressed folders) inside of my VB coding. I have tried making a folder with a ".zip" extension and copying files into it. The result was not a compressed folder. I have looked for a way to address with file attributes...
  6. B

    excel 2007

    How do I assign a cell containing a single letter and a cell containing a numerical value. I want to be able to input a letter and get its assigned numerical output in a different cell. Can someone write me a formula for this?
  7. K

    Strange behaviour

    I’ve made on my computer a dual boot. First: - Windows XP (NLD) - Office 2007 (NLD) - Office 2003 (NLD) Second: - Windows 7 (ENG) - Office 2007 (NLD) If I start with WinXp and run the excel file, in both versions of Excel, then there is no problem. When I start with Windows 7 I get the next...
  8. L

    Vista/Windows Media Player/podcasts

    For better or for worse, I bought a laptop with Vista. I was able to listen to Mr. Excel's archived podcasts beforehand with no problem. It would appear in a new tab in Explorer 7.0. After installing Windows Media Player I have problems. It tries to open in Windows Media...
  9. J

    Excel applications that run in both XP/2003 and Vista

    I have several Excel applications that run fine in XP/2003. I know at some point I will need to re-write them to run in Excel Vista. Have others had success re-writing applications for Vista, yet maintaining compatibility in XP/2003? Thanks. Jeff

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...