Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a row based on other criteria
Is it possible to do this, have two worksheets one with Summary data and one
with Detail data have the Summary sheet constantly look at the Detail sheet and if there has been new data entered on the Detail sheet automatically enter it on the Summary sheet. I have sales orders that have many many items listed for each number (the sales order is unique and can listed a hundred times) them and I want the sales order numer to be entered one time on the Summary sheet and then count how many items there are for that sales order and put it on the Summary sheet. TIA Joe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a row based on other criteria
I want to insert a row at the beggining not add it to the end if it's possible.
Joe "Joe Gieder" wrote: Is it possible to do this, have two worksheets one with Summary data and one with Detail data have the Summary sheet constantly look at the Detail sheet and if there has been new data entered on the Detail sheet automatically enter it on the Summary sheet. I have sales orders that have many many items listed for each number (the sales order is unique and can listed a hundred times) them and I want the sales order numer to be entered one time on the Summary sheet and then count how many items there are for that sales order and put it on the Summary sheet. TIA Joe |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a row based on other criteria
Hi Joe
Depending upon the layout of the data in your Detail sheet, you may well be able to create your Summary by using a Pivot Table report. Take a look at Debra Dalgleish's site for help on setting up Pivot Tables http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/tiptech.html scroll to the section on Pivot Tables or for a video demonstration then look at Mike Alexander's site http://www.datapigtechnologies.com/f...es/pivot1.html -- Regards Roger Govier "Joe Gieder" wrote in message ... Is it possible to do this, have two worksheets one with Summary data and one with Detail data have the Summary sheet constantly look at the Detail sheet and if there has been new data entered on the Detail sheet automatically enter it on the Summary sheet. I have sales orders that have many many items listed for each number (the sales order is unique and can listed a hundred times) them and I want the sales order numer to be entered one time on the Summary sheet and then count how many items there are for that sales order and put it on the Summary sheet. TIA Joe |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a row based on other criteria
Thanks for the idea. I have one problem though I share my Detail workbook
with several others and I saw that a Pivot Table cannot be updated while sharing and you cannot share a workbook with links to another. I don't know if VB would be an answer but I know nothing about VB. Thank you for your advise. Joe "Roger Govier" wrote: Hi Joe Depending upon the layout of the data in your Detail sheet, you may well be able to create your Summary by using a Pivot Table report. Take a look at Debra Dalgleish's site for help on setting up Pivot Tables http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/tiptech.html scroll to the section on Pivot Tables or for a video demonstration then look at Mike Alexander's site http://www.datapigtechnologies.com/f...es/pivot1.html -- Regards Roger Govier "Joe Gieder" wrote in message ... Is it possible to do this, have two worksheets one with Summary data and one with Detail data have the Summary sheet constantly look at the Detail sheet and if there has been new data entered on the Detail sheet automatically enter it on the Summary sheet. I have sales orders that have many many items listed for each number (the sales order is unique and can listed a hundred times) them and I want the sales order numer to be entered one time on the Summary sheet and then count how many items there are for that sales order and put it on the Summary sheet. TIA Joe |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a row based on other criteria
Hi Joe
You are quite correct about shared workbooks and Pivot Tables. You can link another workbook to the Shared workbook, by telling the PT to Get Data from an external source (albeit it is another Excel workbook). It will not refresh whilst the workbook is shared, but once you remove sharing, it can be refreshed, then set the source back to being shared again. Probably not the best way of doing what you want. Before resorting to VBA, if it is only a count of the items belonging to each Order numbers that you want, then you could do the following. Select Columns A and B of Sheet Summary DataConsolidateuse dropdown to Select Counttick Use labels in left columnReferenceclick Browse and select columns A and B of DetailOK I am assuming that column A of Detail contains Order Number and column B will also have values contained on each row. Adjust as appropriate. Just tried this in a Shared workbook and it works fine. -- Regards Roger Govier "Joe Gieder" wrote in message ... Thanks for the idea. I have one problem though I share my Detail workbook with several others and I saw that a Pivot Table cannot be updated while sharing and you cannot share a workbook with links to another. I don't know if VB would be an answer but I know nothing about VB. Thank you for your advise. Joe "Roger Govier" wrote: Hi Joe Depending upon the layout of the data in your Detail sheet, you may well be able to create your Summary by using a Pivot Table report. Take a look at Debra Dalgleish's site for help on setting up Pivot Tables http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/tiptech.html scroll to the section on Pivot Tables or for a video demonstration then look at Mike Alexander's site http://www.datapigtechnologies.com/f...es/pivot1.html -- Regards Roger Govier "Joe Gieder" wrote in message ... Is it possible to do this, have two worksheets one with Summary data and one with Detail data have the Summary sheet constantly look at the Detail sheet and if there has been new data entered on the Detail sheet automatically enter it on the Summary sheet. I have sales orders that have many many items listed for each number (the sales order is unique and can listed a hundred times) them and I want the sales order numer to be entered one time on the Summary sheet and then count how many items there are for that sales order and put it on the Summary sheet. TIA Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count or Sum based on more than 1 criteria | Excel Worksheet Functions | |||
Multiple Sum, based on criteria | Excel Worksheet Functions | |||
Need help looking up value based on criteria | Excel Worksheet Functions | |||
Lookup based on two criteria in 1 row | Excel Discussion (Misc queries) | |||
LOOKUP value based on 2 criteria | Excel Worksheet Functions |