Automating a Summary Tab

  • Thread starter Thread starter H
  • Start date Start date
H

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

Why don't you show us a sample layout of your data and a sample of how you
want it to look.
 
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?
 
H said:
I really appreciate any help here ..
Click to expand...

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
---
 
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!!!
 
Back
Top