Recent content by cmissal

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?

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

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

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

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

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

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

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

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

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

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

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!

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

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

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