Need Check for Blanks formula, please
Excel 2003 SR2
I am combining several worksheets into one. I'm doing this 5 times for 5
alphabetic ranges. Some times I need to combine 4 worksheets, or 5 or 6,
depending if worksheet 5 or 6 have data (if 5 doesn't, 6 will be blank, also).
So - if B1 of Worksheet 5 is blank, I want to jump to the next routine. But
if B1 of Worksheet 5 has data, I want it to process the next instruction,
then go to Worksheet 6 and check B1.
Question - how do I do this?
TIA
CaroleO
|