Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of selected cells from different sheets in a new workbook
I have the productwise data of sales in different sheets. The sheets are the
basically the months. The products are categorised according to their end use. e.g. TV, Music system will be classified as Electronic goods, where as cricket bat, football will be categorised as Sports material. These details are available Sales staff wise. I want to have the output file with details of sale employee wise, monthwise & categorywise. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of selected cells from different sheets in a new workbook
Your life would become a lot easier if all the data were in one worksheet. You
could add another column to indicate the month (and year) and then use data|pivottable to get very nice summaries. Vijay Joshi wrote: I have the productwise data of sales in different sheets. The sheets are the basically the months. The products are categorised according to their end use. e.g. TV, Music system will be classified as Electronic goods, where as cricket bat, football will be categorised as Sports material. These details are available Sales staff wise. I want to have the output file with details of sale employee wise, monthwise & categorywise. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of selected cells from different sheets in a new workbook
Thanks Dave.
I have the data monthwise. In each month the number of line items is 6000. This means 12 months data will contain 72000 line items. This will not fit in one sheet & hence I have to keep the data in different sheets month wise. The output file will have a validation for month. So if I select a particular month, it should display the employeewise & category wise sales. Please suggest. "Vijay Joshi" wrote: I have the productwise data of sales in different sheets. The sheets are basically the months. The products are categorised according to their end use. e.g. TV, Music system will be classified as Electronic goods, where as cricket bat, football will be categorised as Sports material. These details are available Sales staff wise. I want to have the output file with details of sale employee wise, monthwise & categorywise. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of selected cells from different sheets in a new workbook
Apply data|filter|autofilter to each of the worksheets and copy the visible
cells to a new worksheet??? Or upgrade to xl2007. It'll have a million rows. Vijay Joshi wrote: Thanks Dave. I have the data monthwise. In each month the number of line items is 6000. This means 12 months data will contain 72000 line items. This will not fit in one sheet & hence I have to keep the data in different sheets month wise. The output file will have a validation for month. So if I select a particular month, it should display the employeewise & category wise sales. Please suggest. "Vijay Joshi" wrote: I have the productwise data of sales in different sheets. The sheets are basically the months. The products are categorised according to their end use. e.g. TV, Music system will be classified as Electronic goods, where as cricket bat, football will be categorised as Sports material. These details are available Sales staff wise. I want to have the output file with details of sale employee wise, monthwise & categorywise. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet to worksheet . . . | Excel Worksheet Functions | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Max sheets in a workbook or max # of calculated cells | Excel Discussion (Misc queries) | |||
Should be able to name Excel sheets based on cells in workbook | Excel Discussion (Misc queries) | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) |