[Amber Bell]

This is one of my favorite features in GP! It’s been around for ages but many people have never heard of it. This allows you to connect a Excel document (template) or Word template to a SmartList Favorite.

Let me know what you think!

——————————
Amber Bell
Owner
Training Dynamo LLC
Derby CT
——————————

[Joni Finnell]

Thanks Amber! This is awesome!

——————————
Joni Finnell
Project Accountant/GP Troubleshooter
Consumer Support Services, Inc.
Newark OH
——————————
——————————————-

[Maureen Seibler]

Thank you so much for sharing this!

I’ve found many uses for it already and will suggest that we highlight this at our next local chapter meeting.

——————————
Maureen Seibler
Accounting Manager
R2Logistics
Jacksonville FL
——————————
——————————————-

[Amy Clark]

This is fantastic! Thank you for sharing!!

Is there an easy way in a macro recording to get totals at the bottom of columns when there is a varying number of rows based on the search parameters?

——————————
Amy Clark
Jondo, Ltd.
Yorba Linda CA
——————————
——————————————-

[Amber Bell]

You’d have to open the Macro to edit in Visual Basic. I found some options online: https://excel.tips.net/T003217_Using_SUM_In_a_Macro.html
I haven’t tested this fix.

I usually use the Subtotal feature instead of the “Sum” option though. This automatically deals with various row counts.

——————————
Amber Bell
Training Dynamo LLC
Email: amber@trainingdynamo.com
Website: http://www.trainingdynamo.com
Twitter: @trainingdynamo
——————————
——————————————-