I wondering if you could help me with the following? .
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 cost sheet and named the first Sheet "Estimate" 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. from with in sheet "Estimate" when i select an item from database list it will be selected into the current line in sheet "Estimate" with information inserted into the matching columns.
Can this be done and how? or cold some start a template up for me?
Regards
Dan
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 cost sheet and named the first Sheet "Estimate" 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. from with in sheet "Estimate" when i select an item from database list it will be selected into the current line in sheet "Estimate" with information inserted into the matching columns.
Can this be done and how? or cold some start a template up for me?
Regards
Dan