| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking worksheets
I do have a P.O. format that includes data in columns (units ordered and
dollar amounts by unit & total) and rows (each one of the 3 stores). My boss wants me to create a worksheet that gives him the dates, total of units per store, vendor, purchase order #, dollar amounts per unit, and totals. I also would have to create another worksheet that gives him the monthly total figures including almost the same information. Could somebody help me to link the P.O. to the other 2 worksheets? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking worksheets
Use ONE worksheet, and use these Excel features to manipulate it:
Subtotals: http://www.officearticles.com/excel/...soft_excel.htm Autofilter: http://www.officearticles.com/excel/...soft_excel.htm Pivot tables: http://www.cpearson.com/excel/pivots.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Nrippe" <Linking worksheets wrote in message ... I do have a P.O. format that includes data in columns (units ordered and dollar amounts by unit & total) and rows (each one of the 3 stores). My boss wants me to create a worksheet that gives him the dates, total of units per store, vendor, purchase order #, dollar amounts per unit, and totals. I also would have to create another worksheet that gives him the monthly total figures including almost the same information. Could somebody help me to link the P.O. to the other 2 worksheets? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking worksheets
Thank you Anne,
I tried it but the subtotals don't give all the range of data I need. What I have is P.O. template that should be active in a way that when the new P.O. is entered, the data should automatically be included in the monthly breakdown. It also has to include the date link so it goes to the correct monthly sheet. My boss also want to be able to get the annual figures. It's all this possible? I am supposed to get that ready for him ASAP so I am ready for a heart attack. Can you or somebody else help me? Thanks again. "Anne Troy" wrote: Use ONE worksheet, and use these Excel features to manipulate it: Subtotals: http://www.officearticles.com/excel/...soft_excel.htm Autofilter: http://www.officearticles.com/excel/...soft_excel.htm Pivot tables: http://www.cpearson.com/excel/pivots.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Nrippe" <Linking worksheets wrote in message ... I do have a P.O. format that includes data in columns (units ordered and dollar amounts by unit & total) and rows (each one of the 3 stores). My boss wants me to create a worksheet that gives him the dates, total of units per store, vendor, purchase order #, dollar amounts per unit, and totals. I also would have to create another worksheet that gives him the monthly total figures including almost the same information. Could somebody help me to link the P.O. to the other 2 worksheets? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking worksheets
Thank you Anne,
I tried it but it doesn't work. The subtotals don't give the range of data I need. What I have is a P.O. template that should work linked to a monthly breakdown in a way that when a new P.O. is entered the data should automatically go the breakdown page, including also the date link (monthly sheets). My boss also wants to be able to get the annual figures. It's all this possible? I am supposed to have this ready ASAP and I am ready for a heart attack. Can you or somebody else help me? Thanks again. "Anne Troy" wrote: Use ONE worksheet, and use these Excel features to manipulate it: Subtotals: http://www.officearticles.com/excel/...soft_excel.htm Autofilter: http://www.officearticles.com/excel/...soft_excel.htm Pivot tables: http://www.cpearson.com/excel/pivots.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Nrippe" <Linking worksheets wrote in message ... I do have a P.O. format that includes data in columns (units ordered and dollar amounts by unit & total) and rows (each one of the 3 stores). My boss wants me to create a worksheet that gives him the dates, total of units per store, vendor, purchase order #, dollar amounts per unit, and totals. I also would have to create another worksheet that gives him the monthly total figures including almost the same information. Could somebody help me to link the P.O. to the other 2 worksheets? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking worksheets
Why doesn't it give all the range of data you need? I'd have to see your
workbook to be able to answer your other questions. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Linking worksheets ASAP" wrote in message ... Thank you Anne, I tried it but the subtotals don't give all the range of data I need. What I have is P.O. template that should be active in a way that when the new P.O. is entered, the data should automatically be included in the monthly breakdown. It also has to include the date link so it goes to the correct monthly sheet. My boss also want to be able to get the annual figures. It's all this possible? I am supposed to get that ready for him ASAP so I am ready for a heart attack. Can you or somebody else help me? Thanks again. "Anne Troy" wrote: Use ONE worksheet, and use these Excel features to manipulate it: Subtotals: http://www.officearticles.com/excel/...soft_excel.htm Autofilter: http://www.officearticles.com/excel/...soft_excel.htm Pivot tables: http://www.cpearson.com/excel/pivots.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Nrippe" <Linking worksheets wrote in message ... I do have a P.O. format that includes data in columns (units ordered and dollar amounts by unit & total) and rows (each one of the 3 stores). My boss wants me to create a worksheet that gives him the dates, total of units per store, vendor, purchase order #, dollar amounts per unit, and totals. I also would have to create another worksheet that gives him the monthly total figures including almost the same information. Could somebody help me to link the P.O. to the other 2 worksheets? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking worksheets
No, I don't get what I need. Where can I send you a link of what I am looking
for to see if maybe you can help me? I don't see a way to attach the tables here. I am trying my best but I feel just lost! "Anne Troy" wrote: Why doesn't it give all the range of data you need? I'd have to see your workbook to be able to answer your other questions. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Linking worksheets ASAP" wrote in message ... Thank you Anne, I tried it but the subtotals don't give all the range of data I need. What I have is P.O. template that should be active in a way that when the new P.O. is entered, the data should automatically be included in the monthly breakdown. It also has to include the date link so it goes to the correct monthly sheet. My boss also want to be able to get the annual figures. It's all this possible? I am supposed to get that ready for him ASAP so I am ready for a heart attack. Can you or somebody else help me? Thanks again. "Anne Troy" wrote: Use ONE worksheet, and use these Excel features to manipulate it: Subtotals: http://www.officearticles.com/excel/...soft_excel.htm Autofilter: http://www.officearticles.com/excel/...soft_excel.htm Pivot tables: http://www.cpearson.com/excel/pivots.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Nrippe" <Linking worksheets wrote in message ... I do have a P.O. format that includes data in columns (units ordered and dollar amounts by unit & total) and rows (each one of the 3 stores). My boss wants me to create a worksheet that gives him the dates, total of units per store, vendor, purchase order #, dollar amounts per unit, and totals. I also would have to create another worksheet that gives him the monthly total figures including almost the same information. Could somebody help me to link the P.O. to the other 2 worksheets? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking worksheets
No, I have tried everything but I cannot get what I need. I really need
somebody to give me a clue. How can I send you an attachment so you can see the range of data I am working with? I don't know if I can do it here! Thanks again! Nancy "Anne Troy" wrote: Why doesn't it give all the range of data you need? I'd have to see your workbook to be able to answer your other questions. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Linking worksheets ASAP" wrote in message ... Thank you Anne, I tried it but the subtotals don't give all the range of data I need. What I have is P.O. template that should be active in a way that when the new P.O. is entered, the data should automatically be included in the monthly breakdown. It also has to include the date link so it goes to the correct monthly sheet. My boss also want to be able to get the annual figures. It's all this possible? I am supposed to get that ready for him ASAP so I am ready for a heart attack. Can you or somebody else help me? Thanks again. "Anne Troy" wrote: Use ONE worksheet, and use these Excel features to manipulate it: Subtotals: http://www.officearticles.com/excel/...soft_excel.htm Autofilter: http://www.officearticles.com/excel/...soft_excel.htm Pivot tables: http://www.cpearson.com/excel/pivots.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Nrippe" <Linking worksheets wrote in message ... I do have a P.O. format that includes data in columns (units ordered and dollar amounts by unit & total) and rows (each one of the 3 stores). My boss wants me to create a worksheet that gives him the dates, total of units per store, vendor, purchase order #, dollar amounts per unit, and totals. I also would have to create another worksheet that gives him the monthly total figures including almost the same information. Could somebody help me to link the P.O. to the other 2 worksheets? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking worksheets
How can I show the data you need to see? Theer is a way to send you
attachments here? Thanks again! "Anne Troy" wrote: Why doesn't it give all the range of data you need? I'd have to see your workbook to be able to answer your other questions. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Linking worksheets ASAP" wrote in message ... Thank you Anne, I tried it but the subtotals don't give all the range of data I need. What I have is P.O. template that should be active in a way that when the new P.O. is entered, the data should automatically be included in the monthly breakdown. It also has to include the date link so it goes to the correct monthly sheet. My boss also want to be able to get the annual figures. It's all this possible? I am supposed to get that ready for him ASAP so I am ready for a heart attack. Can you or somebody else help me? Thanks again. "Anne Troy" wrote: Use ONE worksheet, and use these Excel features to manipulate it: Subtotals: http://www.officearticles.com/excel/...soft_excel.htm Autofilter: http://www.officearticles.com/excel/...soft_excel.htm Pivot tables: http://www.cpearson.com/excel/pivots.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Nrippe" <Linking worksheets wrote in message ... I do have a P.O. format that includes data in columns (units ordered and dollar amounts by unit & total) and rows (each one of the 3 stores). My boss wants me to create a worksheet that gives him the dates, total of units per store, vendor, purchase order #, dollar amounts per unit, and totals. I also would have to create another worksheet that gives him the monthly total figures including almost the same information. Could somebody help me to link the P.O. to the other 2 worksheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking worksheets | Excel Worksheet Functions | |||
| linking worksheets | Excel Worksheet Functions | |||
| Linking worksheets | Excel Discussion (Misc queries) | |||
| linking worksheets | Excel Worksheet Functions | |||
| Linking worksheets | Links and Linking in Excel | |||
![Nrippe[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
