• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by exceljockey

  1. E

    MS Word macro to pull customer IDs from table

    Hi I am trying to develope a bit of code. So the purpose of the code is to open up word templates, find all of the alternative customer IDs for a given customer and return the values into Excel. The problem I have is not knowing how to make VBA recognise the end of a table. My word vba skills...
  2. E

    VBA to convert .pdf to .txt

    Solved :) Sub convertpdf2() Dim AcroXApp As Acrobat.AcroApp Dim AcroXAVDoc As Acrobat.AcroAVDoc Dim AcroXPDDoc As Acrobat.AcroPDDoc Dim Filename As String Dim jsObj As Object Dim NewFileName As String Filename...
  3. E

    VBA to convert .pdf to .txt

    Hi All I have a problem at work where a lot of files I require in an excel format are already saved as PDFs, and the original excel files have been deleted (and are not retrievable). If this was just for a couple of files, I would manually convert these files into text (so that I can then...
  4. E

    Simple VBA - insert new row underneath selected cell/row?

    No worries I worked it out, was pretty simple: Range(Selection, Selection.End(xlToRight)).Select Selection.Copy ActiveCell.Offset(1).EntireRow.Insert ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.Offset(1, 2).Select ActiveCell.FormulaR1C1 =...
  5. E

    Simple VBA - insert new row underneath selected cell/row?

    Hi Just a simple VBA request. I need a bit of code that tells excel to insert a new row underneath the cell that i've selected; let's say I have selected cell A100, I need to press a macro to insert a new row underneath this cell, so a row A101 will have been created (or a new row A101 and...
  6. E

    Charting events

    Hi Narayan Thanks for your input, I realise its a very complex task (one which is way out of my depth), but its what the manager wants so I have to at least try my best. My solution that I created works fine, but only for static charts, not for dynamic ones; Ideally I need a solution for a...
  7. E

    Charting events

    Hi Jeffreyweir Sorry that I didn't link a workbook; https://www.dropbox.com/s/2bquunsyjauxdx4/book2.xlsm If you go onto chart1 you will see the graph (which takes info from table1), and if you click on a bar you will see what happens with the message box. What I want ideally, if you look...
  8. E

    Charting events

    Hi All I have been looking into charting events to come up with a solution for my problem. I have an interactive dashboard, Chandoo style, and I want it so that when I click on a bar in a bar chart, a pie chart pops up with subsequent information about that bar. So if that bar was a total of...
  9. E

    How to countif when there are duplicate values [SOLVED]

    I have found a fix by using a helper column :) Nice and simple. Will look into what you replied with anyway for the future!
  10. E

    How to countif when there are duplicate values [SOLVED]

    Hi SirJB7 Thanks for the help, this works but only shows how many unique values there were, it doesn't show how many unique values there were UNDER GIVEN CONDITIONS, which is more what I need. Please let me know if you know how to fix this! Thanks EJ
  11. E

    How to countif when there are duplicate values [SOLVED]

    Hi I was previously using Countifs! This doesn't solve my problem however, since multiple rows count as one job. I need to differentiate between unique Order IDs, so essentially I need a FREQUENCY function inside countifs somehow?? That's what im guessing anyway. Thanks
  12. E

    How to countif when there are duplicate values [SOLVED]

    Hi I need a formula solution since its needed for my dashboard; otherwise I would have set up a pivot table as you suggested! Thanks in advance
  13. E

    How to countif when there are duplicate values [SOLVED]

    HI I am currently working with a database which has a bunch of different columns: http://i.imgur.com/WXiV1D1.png Now I need to count how many jobs were received, under two conditions: Month (col 6) & Site_Code (col 3). I did a simple countif to count how many jobs were listed under these...
  14. E

    Simple VBA code, anyone? [SOLVED]

    Hi Guys Thanks for all the help, I have managed to get it to work, It turns out Naranyank was correct! You have helped me greatly, I really appreciate it. In future I will take your advice Hui and upload a spreadsheet after changing the fields and such. Thanks again :)
Top