List of Contributions

Eric Sandberg

Contact Details

My Content

1 to 19 of 19 total

Loop Command to Another Worksheet

Posted By Eric Sandberg 12-02-2021 14:44
Found In Egroup: Automate \ view thread
Hello, how can I specify the loop identifier that is on another workbook sheet? This is the scenario I want to perform. SAP follows the script, and per the steps, it copies the assigned job roles to the new HR position( this is a built SAP command). Then, my script looks over the SAP roles ...

RE: Multiple Sheet Loop Command, Command on Line Item Sheet Help

Posted By Eric Sandberg 03-12-2020 13:14
Found In Egroup: Automate \ view thread
Hello Sigrid, Thank you for the help on this!!!!  I'm playing around with the Index Field, but it's not right.  See screenshot, as I can't write in a ​"IF" command. The reason I want this in different sheets is to avoid this on one sheet: Position - role role role role I guess I could just ...

RE: Multiple Sheet Loop Command, Command on Line Item Sheet Help

Posted By Eric Sandberg 03-12-2020 13:13
Found In Library: Automate

Multiple Sheet Loop Command, Command on Line Item Sheet Help

Posted By Eric Sandberg 03-09-2020 20:41
Found In Egroup: Automate \ view thread
What do I need on either the main master sheet, or the line item sheet to make this work?  Identify unique on both master and then line item sheets, then search and delete if what is in column B (Line Item Sheet) in existing (if exists)? ------------------------------ Eric Sandberg | Sr Financial ...

Multiple Sheet Loop Command, Command on Line Item Sheet Help

Posted By Eric Sandberg 03-09-2020 20:40
Found In Library: Automate

Winshuttle Quits Unexpectantly on Editing Map Lines - My IT Support or Winshuttle Company?

Posted By Eric Sandberg 01-29-2020 20:22
Found In Egroup: Automate \ view thread
​​Hello, I'm trying to modify the mapping lines in a transaction script that has 1,461 lines in Basic View, and 1,492 lines in Expert View. It's rather large.   When I attempt to change a loop command, from single sheet loop to multiple sheet loop, the script goes to "Not Responding', then to a "Winshuttle ...

RE: Updating Loop Command to Another Worksheet in Script

Posted By Eric Sandberg 12-18-2019 14:28
Found In Egroup: Automate \ view thread
I was able to update the loop command, and now that part works. However, ​the rest of the mapping cells are off. I updated some 300 of them by pasting the sheet to each row, but now I still have over a thousand lines to update. Any ideas to mass update each line of my script??? ------------ ...

Updating Loop Command to Another Worksheet in Script

Posted By Eric Sandberg 12-11-2019 20:53
Found In Egroup: Automate \ view thread
I got my script with multiple Excel sheets working!!!! Now, I want to take the template from a working production file, and use it for my template since it has all the fields on the Excel sheet needed. I opened my script, then opened the template I wanted, unassigned the old script and associations from ...

RE: Loop Command to Another Worksheet

Posted By Eric Sandberg 11-11-2019 14:46
Found In Egroup: Automate \ view thread
​I'm getting it, but there are so many options on where to put the formula in the sheet. I wish there were better screenshots for help on loops on this document: docs.winshuttle.com/... I've kept the sheet headers the same. It seems there is an easy fix! Thanks and happy Monday! -------- ...

RE: Loop Command to Another Worksheet

Posted By Eric Sandberg 11-11-2019 14:45
Found In Library: Automate

RE: Loop Command to Another Worksheet

Posted By Eric Sandberg 11-05-2019 17:14
Found In Egroup: Automate \ view thread
Where would the reference to another data sheet go in the script? ​ ------------------------------ Eric Sandberg | Sr Financial Systems Analyst Walt Disney Company - Studio Entertainment | 818-544-9898 ------------------------------

RE: Loop Command to Another Worksheet

Posted By Eric Sandberg 11-05-2019 15:47
Found In Egroup: Automate \ view thread
Thanks Sigrid! Maybe chained scripts would work for this. What I figure, is the delete role area would be better on another sheet, since each line is a new SAP position ​modify command line. That way if I want to mirror a SAP position roles to another SAP position roles, and the mirroring position has ...

Loop Command to Another Worksheet

Posted By Eric Sandberg 10-31-2019 14:53
Found In Egroup: Automate \ view thread
​Hi! Happy Halloween! I've got a loop command on my WS script that works fine. I would like to make the command transfer to another sheet, pick up the selection and then transfer back to the main tab. I'm getting all sorts of syntax lines, and won't therefore debug. What is supposed to happen is ...

Loop Command to Another Worksheet

Posted By Eric Sandberg 10-31-2019 14:52
Found In Library: Automate

Loop Command to Another Worksheet

Posted By Eric Sandberg 10-31-2019 14:52
Found In Library: Automate

Loop Command to Another Worksheet

Posted By Eric Sandberg 10-31-2019 14:51
Found In Library: Automate

Loop Command to Another Worksheet

Posted By Eric Sandberg 10-31-2019 14:51
Found In Library: Automate

Loop Command to Another Worksheet

Posted By Eric Sandberg 10-31-2019 14:51
Found In Library: Automate

Loop Command to Another Worksheet

Posted By Eric Sandberg 10-31-2019 14:50
Found In Library: Automate