Hello everyone and sorry for bad spelling, I'll try to keep it as good as possible.

I have an idea that would make my work a lot more simple. The thing is I have an excel workbook that has around 8 sheet's in it. In each sheet are many lines with information about different products. What I do is, I fill in the number of items needed for each product and then copy into one main sheet all the lines from each sheet that I need and send out offers from the main sheet.

What I need is a way for the main sheet to pull information from other sheets if the number of units for a product is not blank. To make this a little harder, I need to get all the information from the line of the product: Regnumber, name, volume, prize, discount, total prize, total prize with VAT.

I'm thinking about using if to do this, but don't think it's a very elegant way

thanks in advanced
-Harf