MS Excel Script Expert, OfficeScript
Budget: $30 – $250 USD
I'm using Excel script with the idea it can run through a browser on our web-site sometime in the future.
So avoiding VBA for now.
What I want is the ability save/import the green cells in the Summary and Overview tabs with a Name.
Basically, someone in sales will set these values to conform to the customer situation and then save them for both history and possible future use.
Months later, a customer may say - but what about this value? And want a change to one or more of the green cells.
By then, we may have improved the graphics, found bugs (conceptual or formula), or added capabilities (such as graphs to .pdf).
So want to bring in those old values into the latest version.
Thus the "import" function.
Also, it would be great to be able to output the graphs to individual .pdf or jpeg with a click of a button.
I see that scripts don't work on Macs yet and so must be either onedrive/sharepoint or windows excel.
So avoiding VBA for now.
What I want is the ability save/import the green cells in the Summary and Overview tabs with a Name.
Basically, someone in sales will set these values to conform to the customer situation and then save them for both history and possible future use.
Months later, a customer may say - but what about this value? And want a change to one or more of the green cells.
By then, we may have improved the graphics, found bugs (conceptual or formula), or added capabilities (such as graphs to .pdf).
So want to bring in those old values into the latest version.
Thus the "import" function.
Also, it would be great to be able to output the graphs to individual .pdf or jpeg with a click of a button.
I see that scripts don't work on Macs yet and so must be either onedrive/sharepoint or windows excel.