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->U CLICKTH0") ) goes in A1
=TRIM(GMMacro("CONTACT2->U CLICKTH1") ) goes in b5
=TRIM(GMMacro("CONTACT2->U CLICKTH2") ) goes in c 3
=TRIM(GMMacro("CONTACT2->U CLICKTH3") ) 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
=TRIM(GMMacro("CONTACT2->U
=TRIM(GMMacro("CONTACT2->U
=TRIM(GMMacro("CONTACT2->U
=TRIM(GMMacro("CONTACT2->U
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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