View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Netta Netta is offline
external usenet poster
 
Posts: 1
Default Import data to specific cells for a specific row

I have an Oracle table with multiple rows. I would like to import data from
this table into an Excel worksheet. There are two specific issue:
1) I would like to be prompted for a specific identifer to only bring in
one specific row (i.e vendor id)
2) I would like to only bring in specific data from this table and into
specific cells (i.e vendor name goes into cell C3 and vendor classifcation
goes into cell C10).

Is this possible and if so any recommendations on how to accomplish?