I've been working on an idea for a while and need some tips/pointers.

I have a workbook with multiple worksheets. One of these worksheets we
will call my 'Working Budget'. This sheet contains about 40 sections
with the following info.

--Group Name--
-Item 1 || Value 1 || Value 11 || Total1
-Item 2 || Value 2 || Value 22 || Total2
-Item 3 || Value 3 || Value 33 || Total3

Basic format. Each group has a few line items under it, where budgets
are worked out. (Quantity / UoM / Amounts / etc... each translate
across rows to form totals later.

Not all groups will contain data. Until they are manipulated, the
value 1/11, 2/22, 3/33 fields are blank/null.

The last worksheet is my summary page. In this page I want to be able
to have some basic formatting already setup (title bar/logos/etc.).
Then I want the magic to happen. On the 'working budget' worksheet
some groups of the 40 or so have data entered into them. These groups
I want to pull into the summary page.

In basic talk, I want the summary page to be dynamically created and
updated based on the input placed on the 'working budget' worksheet.
When a data field is filled out for Item 1 - Value 1, in the Group
titled "Electrical", then that group no longer is 'empty' 'null' and
will get translated/copied over to the summary page.

I can do some on the fly manipulating and formatting based on some
code with macros. But these are manual runs, and won't update like I
want. (At least not that im aware of).

Any ideas?

No progress thus far.


On Thu, 21 Sep 2006 16:52:12 -0400, J Leckner <(E-Mail Removed)>
wrote:

>I've been working on an idea for a while and need some tips/pointers.
>
>I have a workbook with multiple worksheets. One of these worksheets we
>will call my 'Working Budget'. This sheet contains about 40 sections
>with the following info.
>
>--Group Name--
>-Item 1 || Value 1 || Value 11 || Total1
>-Item 2 || Value 2 || Value 22 || Total2
>-Item 3 || Value 3 || Value 33 || Total3
>
>Basic format. Each group has a few line items under it, where budgets
>are worked out. (Quantity / UoM / Amounts / etc... each translate
>across rows to form totals later.
>
>Not all groups will contain data. Until they are manipulated, the
>value 1/11, 2/22, 3/33 fields are blank/null.
>
>The last worksheet is my summary page. In this page I want to be able
>to have some basic formatting already setup (title bar/logos/etc.).
>Then I want the magic to happen. On the 'working budget' worksheet
>some groups of the 40 or so have data entered into them. These groups
>I want to pull into the summary page.
>
>In basic talk, I want the summary page to be dynamically created and
>updated based on the input placed on the 'working budget' worksheet.
>When a data field is filled out for Item 1 - Value 1, in the Group
>titled "Electrical", then that group no longer is 'empty' 'null' and
>will get translated/copied over to the summary page.
>
>I can do some on the fly manipulating and formatting based on some
>code with macros. But these are manual runs, and won't update like I
>want. (At least not that im aware of).
>
>Any ideas?