Try this set-up ..
Assume you have
In Segment Data
--------------------
In cols A to C, the table:
Project# Field1 Field2
1111 Data1 Data11
1112 Data2 Data12
1113 Data3 Data13
etc
where blank rows (could be 1 blank row, could be several blank rows) have
been set aside for each project to accomodate insertion of future data. It's
assumed that col A is the key column, which will be filled with the project
# from above (1111, 1112, etc) should data input be made in the blank row(s)
Using an empty col to the right, say col E?
Put in E2: =IF(A2="","",ROW())
Copy E2 down to say, E100 to cover the max expected data range
In Sales Summary
---------------------
With the same col headers in A1:C1 :
Project# Field1 Field2
Put in A2:
=IF(ISERROR(SMALL('Segment Data'!$E:$E,ROWS($A$1:A1))),"",INDEX('Segment
Data'!A:A,MATCH(SMALL('Segment Data'!$E:$E,ROWS($A$1:A1)),'Segment
Data'!$E:$E,0)))
Copy A2 across to C2, fill down to C100
(cover the same range as in col E in Sheet1)
Sales Summary will auto-display only those rows from Segment Data which are
populated in col A (Project#). And these will be bunched at the top, with
"blank" rows thrown below - which should hence achieve the same visual
effect spelled out in your lines:
... to hide the rows in "Sales Summary"
if their corresponding rows in "Segment Data" are blank?
Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"KG" wrote in message
...
Here is the problem:
I have one worksheet (we'll call it "Segment Data") containing more rows
than are normally necessary, to accomodate projects that happen to have
more
segments that are average. For most projects, many of the rows will not be
needed and will, consequently, be left blank.
A second worksheet (we'll call it "Sales Summary") will be designed with
as
many rows as "Segment Data" and will be auto-populated with data from the
corresponding rows in "Segment Data." Therefore, if any rows in "Segment
Data" are unused and are left blank, the corresponding rows in "Sales
Summary" will be displaying all zeros.
Is it possible to use Conditional Formatting or other techniques to hide
the
rows in "Sales Summary" if their corresponding rows in "Segment Data" are
blank?