I am trying to collect information from other worksheets, and I want to
delete the rows which are empty.
Basically, I want to search each worksheet for "True/False". If Worksheet 2
has A1=True, then I want to print on Worksheet 1 (my summary sheet) B1 and
B2. If it is false, I want to continue the seach on the second line, etc...
Using an "if" statement will list all the true values, but if the values are
false it leaves a blank line.
I am new to programming, and suspect there is an easy way to create a macro
to solve this?
Any help?
--
Thanks