top of page

Subscribe to future posts by email

Thanks for submitting!

  • Writer's pictureJoel White

100 Thoughts on Pricing (Tools): #73

Despite the drawbacks of macros in Excel pricing tools, what are some of the navigation improvements they work well for?

  • for complex tools with multiple pricing and/or input tabs, macros give you one-click options for opening what you need to see, and closing what you don't,

  • similarly, lengthy input and pricing tabs with grouping and other functionality applied can benefit from macros opening and closing sections within.

  • for tools that require certain selections be made for pricing to advance, macros can take users directly to incomplete items.

  • versioning your budget to the next iteration automatically (e.g., going from Change Order 2 to 3).



bottom of page