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? |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com