Copying parts from a series of worksheets to a master
 

I have set up a bunch of workbooks that calculate hours and material use in
order to bill one of our customers. Right now I have all of the individual
parts listed on the worksheets and the total number used copies over to the
master. What I am trying to find is a way to keep all of the parts on the
worksheets but only have the parts that were actuall used copied over to the
master so everytime we bill the customer there isn't 28 pages of zeros.

Copying parts from a series of worksheets to a master
 

You could try using Data | Auto Filter and then select Non-Blank in the
column showing number of used parts?

"Betsy" wrote:

I have set up a bunch of workbooks that calculate hours and material use in
order to bill one of our customers. Right now I have all of the individual
parts listed on the worksheets and the total number used copies over to the
master. What I am trying to find is a way to keep all of the parts on the
worksheets but only have the parts that were actuall used copied over to the
master so everytime we bill the customer there isn't 28 pages of zeros.