Forum

Unfortunately the caveat of the pivot chart is that it does have to be manually updated by selecting the chart>analyze tab>refresh to get it to ...

I'm sorry, I'm having fun with this challenge. After a bit of finagling, I have come up with a formula to correct the issue in your last formula. The ...

Hi Nick! You're dynamic named range formula is working perfectly, the problem comes with the count. The formula counts the number of non-blank cell...

I don't know if I am missing something, but I'm confused about your reference to cell A3? But as for your automatic print, you can set up a print area...

I finally got it to work! Thank you so much! I had tweak some more, but I think the big issue was using the wrong declaration, thank you!!

Unfortunately that doesn't seem to be the problem, or maybe at least not the only problem...?

I am having more issues! I'm trying to google but I'm not finding the answer that will suffice. I am also trying to have the worksheet check the numbe...

Resize it. If you increase the height of your chart you should be good to go.

That's it! Thank you so much! You're my superstar!!

Good Morning! I have been making the improvements Purfleet suggested. Honestly I'm not sure why I didn't use the simplified Sumif function, thank y...

That didn't work for me? Maybe I should try a message box...

I'm confused as to what you are wanting, from your attached file it looks like you just want to return the string of the named ranges in which case yo...

By jove that fixed my problem!! Thank you so much! I was starting to get frustrated!