| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automating a Summary Tab
I have a workbook that I need a summary page that will breakout 2 different
tabs and subtotal it Is there a way that if 1 tab holds Part #, Desc, and Price Another tab holds Total Price for the type of project it is So that would be: Model, List Price In a Summary tab I would like to show Item # (this would automatically start numbering each row) depending on how many choices they made in the other tabs Part # Description Model Length of term # users List Price They could choose anywhere from 2 parts to 15 parts how do I get it to automatically populate for what they chosen in this new tab? Thank you |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automating a Summary Tab
Hi,
Why don't you show us a sample layout of your data and a sample of how you want it to look. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "H" wrote: I have a workbook that I need a summary page that will breakout 2 different tabs and subtotal it Is there a way that if 1 tab holds Part #, Desc, and Price Another tab holds Total Price for the type of project it is So that would be: Model, List Price In a Summary tab I would like to show Item # (this would automatically start numbering each row) depending on how many choices they made in the other tabs Part # Description Model Length of term # users List Price They could choose anywhere from 2 parts to 15 parts how do I get it to automatically populate for what they chosen in this new tab? Thank you |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automating a Summary Tab
is there a way to attach a sample workbook? thanks :)
"Shane Devenshire" wrote: Hi, Why don't you show us a sample layout of your data and a sample of how you want it to look. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "H" wrote: I have a workbook that I need a summary page that will breakout 2 different tabs and subtotal it Is there a way that if 1 tab holds Part #, Desc, and Price Another tab holds Total Price for the type of project it is So that would be: Model, List Price In a Summary tab I would like to show Item # (this would automatically start numbering each row) depending on how many choices they made in the other tabs Part # Description Model Length of term # users List Price They could choose anywhere from 2 parts to 15 parts how do I get it to automatically populate for what they chosen in this new tab? Thank you |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automating a Summary Tab
Upload your workbook to one of these sites.
http://www.freefilehosting.net/ http://savefile.com/ After uploading, post the URL. Gord Dibben MS Excel MVP On Thu, 9 Jul 2009 08:08:01 -0700, H wrote: is there a way to attach a sample workbook? thanks :) "Shane Devenshire" wrote: Hi, Why don't you show us a sample layout of your data and a sample of how you want it to look. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "H" wrote: I have a workbook that I need a summary page that will breakout 2 different tabs and subtotal it Is there a way that if 1 tab holds Part #, Desc, and Price Another tab holds Total Price for the type of project it is So that would be: Model, List Price In a Summary tab I would like to show Item # (this would automatically start numbering each row) depending on how many choices they made in the other tabs Part # Description Model Length of term # users List Price They could choose anywhere from 2 parts to 15 parts how do I get it to automatically populate for what they chosen in this new tab? Thank you |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automating a Summary Tab
Thank you, here's the URL
Your link to the file: http://www.savefile.com/files/2149776 "Gord Dibben" wrote: Upload your workbook to one of these sites. http://www.freefilehosting.net/ http://savefile.com/ After uploading, post the URL. Gord Dibben MS Excel MVP On Thu, 9 Jul 2009 08:08:01 -0700, H wrote: is there a way to attach a sample workbook? thanks :) "Shane Devenshire" wrote: Hi, Why don't you show us a sample layout of your data and a sample of how you want it to look. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "H" wrote: I have a workbook that I need a summary page that will breakout 2 different tabs and subtotal it Is there a way that if 1 tab holds Part #, Desc, and Price Another tab holds Total Price for the type of project it is So that would be: Model, List Price In a Summary tab I would like to show Item # (this would automatically start numbering each row) depending on how many choices they made in the other tabs Part # Description Model Length of term # users List Price They could choose anywhere from 2 parts to 15 parts how do I get it to automatically populate for what they chosen in this new tab? Thank you |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automating a Summary Tab
Just what you asked for Shane<g
Why don't you show us a sample layout of your data and a sample of how you want it to look. Gord On Thu, 9 Jul 2009 15:58:01 -0700, H wrote: Thank you, here's the URL Your link to the file: http://www.savefile.com/files/2149776 "Gord Dibben" wrote: Upload your workbook to one of these sites. http://www.freefilehosting.net/ http://savefile.com/ After uploading, post the URL. Gord Dibben MS Excel MVP On Thu, 9 Jul 2009 08:08:01 -0700, H wrote: is there a way to attach a sample workbook? thanks :) "Shane Devenshire" wrote: Hi, Why don't you show us a sample layout of your data and a sample of how you want it to look. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "H" wrote: I have a workbook that I need a summary page that will breakout 2 different tabs and subtotal it Is there a way that if 1 tab holds Part #, Desc, and Price Another tab holds Total Price for the type of project it is So that would be: Model, List Price In a Summary tab I would like to show Item # (this would automatically start numbering each row) depending on how many choices they made in the other tabs Part # Description Model Length of term # users List Price They could choose anywhere from 2 parts to 15 parts how do I get it to automatically populate for what they chosen in this new tab? Thank you |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automating a Summary Tab
I'm wondering if it's possible to write some sort of Visual Basic code that
clears it and then somehow populates it again upon open? But, I have no idea how to do that? "Shane Devenshire" wrote: Hi, Why don't you show us a sample layout of your data and a sample of how you want it to look. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "H" wrote: I have a workbook that I need a summary page that will breakout 2 different tabs and subtotal it Is there a way that if 1 tab holds Part #, Desc, and Price Another tab holds Total Price for the type of project it is So that would be: Model, List Price In a Summary tab I would like to show Item # (this would automatically start numbering each row) depending on how many choices they made in the other tabs Part # Description Model Length of term # users List Price They could choose anywhere from 2 parts to 15 parts how do I get it to automatically populate for what they chosen in this new tab? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automating a calendar | Excel Discussion (Misc queries) | |||
| Help Please - Automating Row height | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| Automating using VBA | Excel Worksheet Functions | |||
Hybrid Mode
