Link to home
Start Free TrialLog in
Avatar of goldmineexpert
goldmineexpert

asked on

Excel Update macros

I need to add this value to a specific cell then "hard code the results" . Basically the results replace this value. The macro below is from the Goldmine software link with excel. If you use this link currently it replaces the data each time you open the file with the current data in goldmine. I might have 20 of these macros per worksheet.

=TRIM(GMMacro("CONTACT2->UCLICKTH0"))  goes in A1
=TRIM(GMMacro("CONTACT2->UCLICKTH1")) goes in b5
=TRIM(GMMacro("CONTACT2->UCLICKTH2")) goes in c 3
=TRIM(GMMacro("CONTACT2->UCLICKTH3")) goes in d 4


I in-vision a script that will auto populate all the macros the somehow remove themselves once the data is populated.

Look forward to any questions. Thanks bob
ASKER CERTIFIED SOLUTION
Avatar of krishnakrkc
krishnakrkc
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of goldmineexpert
goldmineexpert

ASKER

Hey Kris,

I would like you to work on this project for me. Do you have time to chat today via phone?

My email is bobm@contact-mgt.com. Please let me know if you have time today.

Thanks bob mcc