LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
 
Posts: 57
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating a calendar Lofty Excel Discussion (Misc queries) 0 November 28th 06 03:21 PM
Help Please - Automating Row height baz Excel Discussion (Misc queries) 1 November 29th 05 07:08 PM
multi group with summary above with 1 overall summary line below Freddy Excel Discussion (Misc queries) 2 November 7th 05 03:30 PM
multi group with summary above with 1 overall summary line below Freddy Excel Discussion (Misc queries) 1 November 1st 05 08:50 PM
Automating using VBA Automate my database Excel Worksheet Functions 1 September 1st 05 01:51 PM


All times are GMT +1. The time now is 12:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"