Insert Items From Another Sheet

[Dancaw]

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

 

[texasalynn]

Welcome to MrExcel board...

those are both doable options. To create the drop-down lists with items on another sheet you will need to name the ranges, then with the data validation lists. The other options can be done with if statements using vlookup formulas. Example:

=if(a2="","",if(isna(vlookup(a2,yourtablerange,columnnumberhere,false)),"",vlookup(a2,yourtablerange,columnnumberhere,false))

 

[Dancaw]

Well thank you for the quick response Lynne,

your have to break down your steps as that formula doesn't mean much to me sorry.

I Know if i Put the forms tool bar on i can create a drop down list. i don't really wont that. as some times i might want to type in a special item what's not from my database list and using that form of drop down create like a floating drop down.

 

[Dancaw]

Thanks, I've Managed to figure it out.

 

[texasalynn]

Glad you were able to work it out.