Contact Me

Would you like to suggest a topic for a future blog post?  Do you have any suggestions for me to improve my blog?  Do you know me and want to reconnect? Whatever your reason is for contacting me, I’d love to hear from you. The easiest and fastest way to get in touch with me is to send me an e-mail.  My e-mail address is my first name (Dustin) @ my domain (dustinwheelercpa.com).

Comments (1)

  • Avatar

    Tatum Nolan

    |

    Hi Dustin!

    I found your blog post from a decade ago regarding macros for QB exports. You had asked if there were any suggestions. I have one! I am decent at Macros, but haven’t been able to crack this one.

    QB exports (e.g. Open POs by item) have an incomplete structure that makes it impossible to make a pivot table without lots of data munging. For instance, for product XYZ, there are, say, 10 related POs. But the XYZ is only populating the first row. In order to build a pivot table, I have to manually copy the value down across the applicable POs. I have thought about a macro that says, “if this field is populated, keep it as is, but if it’s blank, then populate with the cell above. But this doesn’t work. The problem (I think) is that macros aren’t sequential. They don’t do one row, then the next. It is calculated in a batch.

    Does that make sense? Any guidance here? It’s hard to talk through, but i’d be happy to send you a version by email. Thanks for all you do!

    Tatum

    Reply

Leave a comment