Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting - Pulling from worksheet to form summary page - only non-null fields/sections pulled
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting on Null Value | Excel Worksheet Functions | |||
Conditional Linking and Formatting across worksheets to form Summary Page - Only pull/link non-null fields | Excel Worksheet Functions | |||
Conditional formatting based on not null value | Excel Programming | |||
Pulling selected data from a detail page to a summary | Excel Discussion (Misc queries) | |||
Pulling information from a worksheet into a user form | Excel Programming |