J
J Leckner
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?
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?