Search results

I believe the issue lies in this syntax: If Not tbl Is Nothing Then It is always displaying the table as empty so it skips and goes to the next MyCell

Luke, Thanks for the post. I have tried a couple of things and still not working. It is still selecting the empty table and trying to copy and paste and I get an error message. The error message pixs are attached. I know it is something simple but can't figure it out. Never happened to me...

Thanks Luke. There is no error but now it just loops and doesn't select the table and then copy it to the other workbook. I will take a stab at it again to see why it is not selecting and then copy. Here is the modified code: '----------------- CODE TO COPY TO DRG TAB Sheets("DRG Sender...

Hi, I am having an issue with my code. I have a code that filters and copy to a different workbook. If the filtered table has no data, i do not want to copy and move to the next parameter in the range that needs to be filtered. Here is my code below and I am getting this error message...

Thanks Luke. I will try it. When I wrote the formula, it seem to me the syntax was off but did not know I had to declare and set the ranges.

Hi all, I have a table that changes based on the text in the dropdown. The name of the dropdown is Trend Drop down and the name of the table is Yearly Trend Tbl. Two of the metrics in the table should be formatted as percent while the remaining selection should be formatted as number with comma...

k. Thanks Hui. it probably was just a glitch.

It is located on the sheet called "dashboard". Thanks Hui.

k. I found the solution for the first issue but still have issue with the second problem. any help would be appreciated

to all, how are you? I created a dashboard based on selection in multi-level list box but the list box has 2 major issues: 1. it automatically resizes when the file opens so my up and down selection arrow is not visible 2. the list box doesn't automatically populate initial when it is open. I...

Thank you. It was a security issue on my computer.

I saw this already but the problem is that it doesn't work on a dynamic chart where I a user can select multiple items to chart. see tab titled" Mulit-Selection Trend View". I couldn't find a macro that will do it. before I record a macro and alter the code, I wanted to see if someone had one...

can anyone direct me to a macro that only displays first and last data point on a chart? I appreciate it

does anyone know how to make a macro work on a protected workbook. see the attached file as an example. It is protected. On sheet "GLC Trend View" the listbox is populated via macro. when the workbook is protected, it is saying my security level is too high. I have enabled all macros so this is...

When you open the file, you have to click on the orange up button first and then you will see the error

Here you go.

To all, I need help. I created a listbox on sheet titled "GLC Daily Trend View". For the life of me, when you open excel, the listbox won't populate. It will only populate when you click the orange down button. When you click the orange up button an error message pops up, see below. The VBA...

Thanks Hui. What do you feel is a more efficient way of calculating this part? Thanks

To all, I created a dashboard and the calculations I have are slowing the dashboard significantly. I have made some modifications to increase speed but it is still taking too long for the calculation when I change a parameter or even change views. I need help. What can I do from a maintenance...

after further review, I do not believe it is the listbox. I believe my calculations are slowing the dashboard. I will move this discussion to another forum.

To all, I created a dashboard that utilizes a drill down listbox but the macro is causing the speed of the dashboard to go extremely slow. Can anyone help with suggestions on how to optimize the dashboard for quicker calculation? I tried using ApplicationScreenUpdating and it doesn't work...

I modify it a bit but when I click on Clinical Operations, the selected range is not populating the list box. Can you tell me where I am going wrong? Thanks

thank you but I will have to modify. I want the ability to drill up a level. when you click the back button, it goes to the very first list "GLC". That is the reason why I have the up and down arrow. I really appreciate your help and will learn a lot from you. Another issue is the Clinical...

Here is one that is perfect that I am trying to emulate. look at the last tab called trend view. this is a perfect example. https://www.dropbox.com/s/zjc2e261rosrhb0/Sales%20Admit%20Target%20Achievement%20Report%20WE%202014-08-03.zip?dl=0

thanks Nebu. To answer your question, if you click on a state that is shown in Column F, then the list of facilities in Column G will show up that is in that state. Also, there is an error. When you click on Clinical Operations, GA in Column D should show up, but currently there is nothing. I...