Look Up Insert.

F

Funkydan

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
 
A

albertmb

Would gladly try to help you, please send me layout and what you need on
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top