Excel Inport External Data - new queries
 

I want to import data from Pronto which will be sorted by stock codes and
warehouses. Can I have more than one query in a spreadsheet? I seem to only
be able to get all warehouses in one sheet. I would like to have each
warehouse come up in a separate sheet.
Any suggestions will be greatly appreciated

Excel Inport External Data - new queries
 

hi
you can have as many querries as you want. limited by available resources.
as you described, you would need a querry for each warehouse. you can copy
your current querry and paste in on a second sheet. the right click somewhere
within the querry range, click edit querry. on the second screen of the
querry wizard you can specify the individual warehouse for that querry.

hope this helps
regards
FSt1
"Lozza65" wrote:

I want to import data from Pronto which will be sorted by stock codes and
warehouses. Can I have more than one query in a spreadsheet? I seem to only
be able to get all warehouses in one sheet. I would like to have each
warehouse come up in a separate sheet.
Any suggestions will be greatly appreciated