Excel Inport External Data - new queries

  • Thread starter Thread starter Lozza65
  • Start date Start date
L

Lozza65

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
 
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
 
Back
Top