fill external data in specific cells of various sheet
 

I need to fill data from oracle (order) into protected workbook (order form)
into various sheet and specific cells.

oracle table (model and size is primary key)
model size quantity
001 1 1
001 2 1
002 1 4
003 1 2
003 2 2
003 3 1

Excel form
A B C D
1 model size/quantity
2 1 2 3
3 001 1 1
4 002 4
5 003 2 2 1

any suggestions to fill easy data from oracle into predefined excel order
form..

fill external data in specific cells of various sheet
 

On Dec 10, 8:30 am, "Tomo" wrote:
I need to fill data from oracle (order) into protected workbook (order form)
into various sheet and specific cells.

oracle table (model and size is primary key)
model size quantity
001 1 1
001 2 1
002 1 4
003 1 2
003 2 2
003 3 1

Excel form
A B C D
1 model size/quantity
2 1 2 3
3 001 1 1
4 002 4
5 003 2 2 1

any suggestions to fill easy data from oracle into predefined excel order
form..

I'd just query the database into a recordset and then loop through the
results placing the items you want into the cells you want. Many
different ways to skin that cat and I'm sure someone can show you
something easier, but that would be my approach.

Cory