Forum

I don't know a whole lot about PQ, this is the first project I've tried it on. As long as it can be used to feed the pivot table, no the table result ...

I don't think it's possible. They are two very different databases but so I don't think you could write VBA code to control Google Sheets (the pasting...

Hi Steve, I'm glad everything made sense to you and wasn't too confusing. You've got this!

Here's my take on it - in the end your lending balance is zero. In your PMT function you were using the new balance to calculate the payment - I'm ...

Hi Vasim! I'm sorry, but I have no clue what you are trying to do here. Can you explain further?

Thanks for catching my mistake Velouria!

No worksheet attached. Don't forget to click upload before posting. But it should be something like this assuming the function is in cell J1. =if(C...

Thank you so much!

You're there! The only changes you need to make are to move the "on error" command before your value command and exit the sub before your msgbox error...

Glad to help!

Absolutely, for that you will need a dynamic named range. They are amazing and once you know them you will use them often! Then update the formula in ...

You'll need a helper cell to find the latest date then draw your textbox and have it reference the helper cell. The formula to find the latest date wo...

Mike, You are stressing over this test - breathe, you've got this! I have faith in you! Anders gave you a good starting point of finding great mat...