Thread: 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.

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.