Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transferring data from multiple sheets in workbook to one sheet
I have a workbook with 10 sheets. One sheet is the "master"; initially it is
blank except for the headings at the top of 6 columns. The other 9 sheets represent 9 categories of products customers can buy. The names for each of these 9 sheets reflect the product categories. Each of these 9 sheets includes 10 - 70 rows; each row represents a different product; each of these sheets has six columns (mfg, part#, descrip, cost ea, qty, total cost). Starting with all "qty" at zero; the customer would go through each of the 9 sheets and enter the quantity of each product he wants to buy. At this point I want a copy of all information in a row in which the "total cost" is greater than zero to be placed in the "master" sheet which would have the same six columns as the other nine sheets. In this way I can look at only the master sheet to see what the customer has ordered. Of course, if the customer goes back into any of the 9 sheets and changes products or quantities, I would want these changes reflected in the Master Sheet. How would I do this? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring data from multiple sheets in workbook to one sheet | Excel Discussion (Misc queries) | |||
Transferring data from multiple sheets in workbook to one sheet | Excel Worksheet Functions | |||
transferring total sheet from one workbook to another | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
copy data in one sheet to multiple sheets in same workbook | Excel Worksheet Functions |