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

Search results

  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 :)
  15. E

    Simple VBA code, anyone? [SOLVED]

    Unfortunately I cannot do that - private information and what not... Ill try it on a blank excel sheet and see what happens!
  16. E

    Simple VBA code, anyone? [SOLVED]

    Hi I have tried doing this, it didn't work. In fact all it did was make the entire thing not work so no zoom works at all with this code, but I don't see why since the code makes sense... Maybe I should try a different solution to this problem like a combo box or something.
  17. E

    Simple VBA code, anyone? [SOLVED]

    Right So I have tried to play about with what you just replied with, I have written this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("B4,C4,D4,E4,B17,B30,T3,T15")) Is Nothing Then ActiveWindow.Zoom = 70 ActiveWindow.ScrollColumn = 1...
  18. E

    Simple VBA code, anyone? [SOLVED]

    Thanks for the reply, so basically the reason behind all of this is because I have some drop down lists on my dashboard and as you know, the tiny font in the drop down lists is not user friendly. My aim is to zoom into the cell when I click the cell, but also to center the screen while doing it...
  19. E

    Simple VBA code, anyone? [SOLVED]

    Hi I am pretty new to writing code. I am trying to achieve something on my dashboard. The Logic goes as follows: If Cells B4,C4, or D4 are selected, then zoom in 120%. If cells T3 or T15 are selected, then zoom in 120% AND scroll right 15 columns. If cells B17 or B30 are selected, then zoom...
  20. E

    Data Validation Zoom VBA (need scroll added)

    So I updated the code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.ScreenUpdating = False If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, Range("B4,C4,D4,E4,B17,B30,T3,T15")) Is Nothing Then ActiveWindow.Zoom = 70 ActiveWindow.ScrollColumn =...
  21. E

    Data Validation Zoom VBA (need scroll added)

    Hi I am working on a dashboard and have a few data validation drop down lists on it. The problem is that when I click on the drop down list, the font is so tiny that its hard to read, and therefore not user friendly. I found this code online to help my problem, what it does is zoom into the...
  22. E

    Interactive bar chart - pie chart

    Thanks a lot Narayank! Going to give this a read when I have some spare time - it looks like it will help solve my problem.
  23. E

    Index help please! [SOLVED]

    Thanks for your help guys, I found the solution thanks to Hui's pointing in the right direction - answer lied in Maxif. Thank you very much!
  24. E

    Interactive bar chart - pie chart

    This is a nice link! But doesn't really help my problem, any idea where to start looking?
Top