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

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

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

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

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

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

Automating a Summary Tab
 

I really appreciate any help here I'm supposed get it out early next week?

"Gord Dibben" wrote:

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

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

Automating a Summary Tab
 

"H" wrote:
I really appreciate any help here ..

Try this sample from my archives:
http://savefile.com/files/1898492
Automated Order Summary.xls

A simple, effective automated model (formulas driven) which drives out a
neatly packaged order summary based on items ordered (qty 0) in a source
catalog. Includes provision for 2 total qty/items lines to be brought over.

Wave it here if you find this response helpful. Click YES.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Automating a Summary Tab
 

hi Max,

Thank you for this example.. I am still struggling to make this work tho'
and sometimes the part # is free so the result can be zero? Do you have
possibly any suggestions?

Thanks again!!!


"Max" wrote:

"H" wrote:
I really appreciate any help here ..

Try this sample from my archives:
http://savefile.com/files/1898492
Automated Order Summary.xls

A simple, effective automated model (formulas driven) which drives out a
neatly packaged order summary based on items ordered (qty 0) in a source
catalog. Includes provision for 2 total qty/items lines to be brought over.

Wave it here if you find this response helpful. Click YES.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Automating a Summary Tab
 

Here's some thoughts, adapted/built-into your sample file:
http://www.savefile.com/files/2152924

It'll achieve the automation that you seek for your "Sales Quotation", based
on product selections in "Addtl Products"
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"H" wrote:
hi Max,

Thank you for this example.. I am still struggling to make this work tho'
and sometimes the part # is free so the result can be zero? Do you have
possibly any suggestions?

Thanks again!!!