Excel 2007 : Populating from one worksheet to another.

[matador1]

I have a excel worksheet for rehabbing houses. It has each room listed with each item listed that could be needed, see attached


What I want is that when I list a Unit in the cell it populates a Contractor Bid Sheet. I can make it populate if I go to the Contractor Bid Sheet and put a new line for each item in it but then you have a lot of lines blank based off of the level of work needed.
I want someway to populate a list with no blanks. Am I making sense?
Form attached

[Steve R]

I am not sure i understand you, but i did try.

Check out the attached file.

[matador1]

I am not sure i understand you, but i did try.

Check out the attached file.

That is very close, I would need it to add common items such as... Install 5 ceiling fans, install 140 sq feet of carpet, etc.

[Steve R]

See file attached

[matador1]

I think that is it, thanks. I am going to test further on Monday.