print button help

i have a workbook with several sheets. one of the sheets is my data base sheet. it has over 500 products listed in it…i want to be able to print only the ones out of this 500 that actually have a number in the column..this coulmn would be g1:g500.i also only want to print column a,b,and g. i want it to go to my default printer..and i want to have a button that says print on it on my sheet 2 at b9…can you show me how this be done automation style?