Recent content by exceljockey

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

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

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

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

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

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

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

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

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

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

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

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

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

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 :)