Automate

Hi Everyone,

I'm trying to make a data entry form in Excel to capture material master data. 

What I want to achieve is:

• The end user provides a 'copy-from' material number in a cell.
• All other fields would be populated using vlookup formulas to other tabs, on which I downloaded several tables with Winshuttle query.
• The end user reviews the data as needed & sends it back to the master data team.
• The master data team uploads the data to SAP.

So far so good... What I can't figure out is an easy way to automate the query process. I think I got 2 options here:

• Do the downloading process manually (which will take some time to run all the query's)
• Schedule the query's, but then I still have to copy the new data in my data entry form.

Are there any other solutions with Winshuttle Studio 12.1? 

Thanks in advance.

Using Winshuttle Studio 12.1

Hi Nick,

I'm using VBA for this sort of manipulations ... getting data from different sources and gathering all data into an uploadsheet, ready for WS-uploadscripts, can easily be done with a little VBA scripting. Not only very fast but also, most importantly, errorproof.

best, Jan