Quote- Conditional automatic copy from sheet 2-4 back to sheet 1

eastoz Posts 1 Registration date Sunday November 2, 2014 Status Member Last seen November 2, 2014 - Nov 2, 2014 at 02:27 AM
Hi, does anyone know how to do the following.
I want to automatically copy a product description and number of items to a front quote page (sheet 1) when a number is placed in the number of items required on sheet 2 or 3 depending on the item. Sheet 2 has approximatly 1000 items, sheet 3 and 4 around 200 each, and only 1 to 10 items would be selected on any given quote.
Anyone have any ideas?

Kind Regards