Automate

Hello Community!

As we are acquainting ourselves with our new Automate Studio setup, a question has come up a couple times: is it possible to use multiple sheets in the same Excel workbook/data file?

We are wanting to put the Extended Log in another sheet than the main sheet where Runners are doing their data entry. 

Has anyone successfully been able to pull something like that off, or have any tips and tricks for adding more than one sheet in a data file?

Thanks in advance for your suggestions! 

------------------------------
Samuel Varney
Cooperative Regions Of Organic Producer Pools
------------------------------

Hi Samuel

This is not currently possible.

The only option we have to multiple sheets is a multi-sheet loop where the header information is on one sheet and details on another.  Each sheet has to specify a "key" to match them up, i.e. this header goes with these detail lines.

If the goal is to have a separate sheet for inputs and another sheet to load the data with messages, we have some customers who have used macros to do that formatting/transformation/copy.  However, the messages still go on the sheet with the data you are uploading.

If this doesn't help, please consider submitting an improvement idea on the Ideas portal here: https://ideas.precisely.com/?project=ST.  .

Best Regards,

Sigrid

------------------------------
Sigrid Kok
*Precisely Software Inc.
------------------------------