Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying worksheets | Excel Worksheet Functions | |||
copying addresses from one workbook to another into several worksheets | Excel Worksheet Functions | |||
Copying Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
HELP- Copying a Data Series to Another Graph??? | Excel Discussion (Misc queries) | |||
fill a particular cell on a series of worksheets from a lookup tab | Excel Discussion (Misc queries) |