Look Up Insert.
 

Hi Every one.

im trying to create something which seems rather complex for me. and i
was wondering if it could be done and how?

I've just created a costs sheet and named the first Sheet "Costs" with
following columns (Qty, item, Unit Rate, Unit Discount, Unit Total,
Unit Labour& Total labour).

then I've Created a Second Sheet labeled "Database" and with in that
sheet i have following columns
(Item, Unit Rate, Unit Discount, Unit Labour)

This sheet will list day to day materials i will use on a daily basis
and instead of having to retype them every day i could just select
them on a drop down or something like that. when i select an item from
database it will be selected into the current line in sheet "Costs"
with information inserted into the matching columns.

Can this be done and how? or cold some start a template up for me?

Regards

Dan

Look Up Insert.
 

Would gladly try to help you, please send me layout and what you need on


"Funkydan" wrote:

Hi Every one.

im trying to create something which seems rather complex for me. and i
was wondering if it could be done and how?

I've just created a costs sheet and named the first Sheet "Costs" with
following columns (Qty, item, Unit Rate, Unit Discount, Unit Total,
Unit Labour& Total labour).

then I've Created a Second Sheet labeled "Database" and with in that
sheet i have following columns
(Item, Unit Rate, Unit Discount, Unit Labour)

This sheet will list day to day materials i will use on a daily basis
and instead of having to retype them every day i could just select
them on a drop down or something like that. when i select an item from
database it will be selected into the current line in sheet "Costs"
with information inserted into the matching columns.

Can this be done and how? or cold some start a template up for me?

Regards

Dan