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

  1. C

    Chandoo, I sent you an email but you claim not to read it but once a month. one of your staff...

    Chandoo, I sent you an email but you claim not to read it but once a month. one of your staff members, "bobhc" is stalking my posts, and sending me harassing/inappropriate/threatening private conversation messages. How do your moderate your moderators?
  2. C

    How do I convert an existing Chart to VBA Code?

    For anyone interested, I was able to solve my challenge without having to program the charts in VBA. It was rather obvious -- Instead of simply copying the 'chart' worksheet from the sample file to my new file with VBA code, I copied the 'chart' and 'data' worksheet that the chart referenced...
  3. C

    How do I convert an existing Chart to VBA Code?

    vletm, I uploaded the files to the private conversation you started. Thanks! Casey
  4. C

    How do I convert an existing Chart to VBA Code?

    Thanks both of you. I am relatively familiar with VBA and have done extensive VBA charting/sparkline dashboards in the past, but that was years ago. I figured the easiest thing would be to, as I mentioned, simply populate the data source for existing charts that were created. Not working as...
  5. C

    How do I convert an existing Chart to VBA Code?

    Hi, It's been a while since I have worked with Excel VBA so I'm trying to get back up on the horse. I created a form on worksheet "Admin" to allow user to select multiple text data sources and ingest them (different criteria depending on the file format). These files populate a table on a...
  6. C

    Use Structured Reference to locate value in cell in previous row of table

    This is what I came up with. Please let me know if you have a more efficient method. The formula for the "TestColumnPreviousRowValue" in the original psudocode is: INDIRECT(ADDRESS(ROW(MyTable[AnotherTestColumn])+MATCH(MyTable[[#This...
  7. C

    Use Structured Reference to locate value in cell in previous row of table

    I know how to get the value of an cell in a table if the cell is in the same row using the structure Reference "special item specifier" [#This Row], but I was wondering if anyone had a quick/efficient way of locating a value 1 (or more) rows above (or below) the current row. I figure I will...
  8. C

    Help with Data Filter and Filter Results Table (not range)

    Narayan/Hui, I have implemented the following code which takes the 'n' rows of my filtered data from the hidden 'calculations' worksheet, inserts 'n' blank rows in my instruction form/worksheeet and pasts the values in the new blank rows. I still need to add the conditional formatting to each...
  9. C

    Help with Data Filter and Filter Results Table (not range)

    Narayan, The filter results are posted to an hidden worksheet, so I could use your approach and just perform the count row/copy without deleting the sheet when I am done. I will try it. Hui, The worksheet I want to post the results back to are the 'instructions' sheet for refreshing the...
  10. C

    Help with Data Filter and Filter Results Table (not range)

    I have a filter in my VBA code which works fine, and copies the output to a second table for me to perform additional steps with. Range("Table_Data_Current_Wk_Schedule").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("adminMilestonesFilterCriteria")...
  11. C

    How do I use VBA and variables to create dynamic import connections?

    Hi Hui! I didn't see your response previously. I am referring to a "Data Connection" to another workbook, not a cell reference to another workbook. Basically, I have tables in my 'dashboard' workbook and part of the instructions have users trigger VBA events by clearing contents of an...
  12. C

    How do I use VBA and variables to create dynamic import connections?

    Bump. If no one has a quick solution, I would at least be greatful for some direction as to where I should begin my research. thanks!
  13. C

    How do I use VBA and variables to create dynamic import connections?

    I have been building a dashboard that, at present, requires strict path/filenames for import files. When I trigger the import refresh VBA code, I want it to update the connection string to use the value stored in the cell referenced by a Name as the path/file. (I am importing .xlsx file type)...
  14. C

    Help with the ShowHelp() function

    I am incorporating the ShowHelp() function that is included in the Dynamic Dashboard Illustration v1.1 file (and instructions). Has anyone modified to make it more context sensitive? I would like to create help buttons on various pages or locations within a page and, based on a parameter or...
  15. C

    VBA to change Header Picture?

    I have done extensive research, and the only thing I seem unable to do to completely format my print page headers using VBA is insert a picture. Ideally I could select an picture object (or cell range) that my end user inserts in a setup worksheet. Does any know a work around for this? I am...
Top