Had some great help on here from certain individuals, just after a little bit more as im stumped!
My spreadsheet which tracks my stock is attached.
What i need to happen is that if any one item is selected in column B6:B100 from a value of 1< i need information out of cell A6 B6 I6 and J6 Copying in to a table format on Sheet 2. This is so i can print the invoice off sheet 2 without the customer obviously seeing my materials costs and stock etc.
It would also be great if i could get the labour costs (net,gst and Gross) in cells F106:F108 into the the new table on sheet 2.
Any help would be greatly appreciated!!