I have a workbook with 8 worksheets and there is a macro involved which
drives 2 of those worksheets to copy information from 1 of the other
worksheets.

My question is, is there a way to automatically show only the rows on those
2 worksheets in which data has been put into the corresponding rows from the
first work sheet.

For example lets say
1) worksheet 1 is my pricing page with part number, quantity, cost, sell, etc.
2) worksheet 2 is my quote page in which I only want to show part number,
quantity and sell
3) worsheet 3 is my purchasig page in which I only want to show part number,
quantity and cost.

I only want worksheet 2 & 3 to show rows with data entered.

Thanks