clear range of cells if another becomes blank
 

I want to clear a range of cells on a sheet if a cell that has a formula
=INF!B2 becomes blank by clearing the data on the INF sheet cell B2

clear range of cells if another becomes blank
 

=INF!B2

Just hazarding a thought that
perhaps you might be looking for something like this instead:
=IF(INF!B2="","",INF!B2)

Copy the formula across/down as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bgg" wrote:
I want to clear a range of cells on a sheet if a cell that has a formula
=INF!B2 becomes blank by clearing the data on the INF sheet cell B2

clear range of cells if another becomes blank
 

I'll try to better explain what I am trying to achieve
I have two sheets in a workbook,one labeled INF and one labeled AB
I enter a name in cell B2 on INF sheet,than on sheet AB in B3 I have
=IF(INF!B20,INF!B2,"")
Now I have dates that I enter on sheet AB row B3:F3
I wish the contents in cells B3:F3 on AB sheet to be cleard when I clear the
contents in B2 on the INF sheet

"Max" wrote:

=INF!B2

Just hazarding a thought that
perhaps you might be looking for something like this instead:
=IF(INF!B2="","",INF!B2)

Copy the formula across/down as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bgg" wrote:
I want to clear a range of cells on a sheet if a cell that has a formula
=INF!B2 becomes blank by clearing the data on the INF sheet cell B2

clear range of cells if another becomes blank
 

.. on sheet AB in B3 I have
=IF(INF!B20,INF!B2,"")

You probably mean in B2, not B3 (guess it's a typo?)

Ok, guess I'm out here. You would need a sub to do what you want. Hang
around awhile for insights from others versed in vba. If nobody jumps in
here, you could put it in a fresh posting (use your better description
below, but corrected for the typo) in excel.programming.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bgg" wrote in message
...
I'll try to better explain what I am trying to achieve
I have two sheets in a workbook,one labeled INF and one labeled AB
I enter a name in cell B2 on INF sheet,than on sheet AB in B3 I have
=IF(INF!B20,INF!B2,"")
Now I have dates that I enter on sheet AB row B3:F3
I wish the contents in cells B3:F3 on AB sheet to be cleard when I clear
the
contents in B2 on the INF sheet