Automating a Summary Tab

[H]

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

 

[Shane Devenshire]

Hi,

Why don't you show us a sample layout of your data and a sample of how you
want it to look.

 

[H]

is there a way to attach a sample workbook? thanks

 

[Gord Dibben]

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

 

[H]

Thank you, here's the URL
Your link to the file: http://www.savefile.com/files/2149776

 

[Gord Dibben]

Gord

Thank you, here's the URL
Your link to the file: http://www.savefile.com/files/2149776

 

[H]

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

 

[H]

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?

 

[Max]

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
---

 

[H]

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]

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