Dear all
I want to have a workbook with on the first page a formula that prints out information of sheet 2-9.
if you look at the attached file in colom A B and C you see some numbers and in D would be the information i want to print out. these numbers in A B and C are attached to information in sheet 2 with an Unique code. So if i select this Unique code in a dropdownlist in sheet 1 i want my fucntion to look for the number and print out the information of the colom Below. this can be text or attached pictures. As you can see some have only a few rows while others are bigger.
so lets say my uniqe code is XA15 connected with 11.01 then i want everything printed out between row 31 till 43 text and pictures.
Is that possible ? if yes how
thank you very much
