Or a Macro / VBA??

[robert morris]

Problem: Is there a way to Auto Un-hide a Row (one at a time) of 10
Formatted and Hidden Rows. Example;

Col Col Col Col
Col Col
B7 C7 D7 E7 F7
G7
Date Desc Progress Contract Amount
Balance

We have approx 20 of the above, each with Borders around Ranges as B7:G18
for the first; 2nd B20:G31 3rd B33:G45 and on

This works but is just too cumbersome to hide/unhide Rows and the additional
problem of Page Breaks enters as more Rows are Un-hidden. I cannot have a
Page Break in the middle of a Vendor Box.

Simply want the foreman to enter Date/ Progress Comments/ Amount of
Draw Save and Print.

I hoping there is help somewhere, even if Macro/VBA neither of which I can
do but I can copy.

Please?

Bob M

 

[Gary''s Student]

You don,t need a macro or VBA. Excel has a built-in feature call AutoFilter.
It allows you to specify rows to display based upon criteria from any or all
of the columns.


For a good description see:

http://www.contextures.com/xlautofilter01.html

 

[robert morris]

Gary's Student

Thanks for the reply, although I'm just trying to teach myself all the extras
in Excel. Perhaps I was now totally clear. Would it help to send my
worksheet
via email?

Bob M.

 

[robert morris]

Gary,

I'm not sure as yet that AutoFilter is what I need. If I have text/data in
Rows 7 & 8, when I finish entering data in Row 8, I just need Row 9 to
"unhide" automatically.

Any clearer?

Thanks,

Bob M.