View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carole O Carole O is offline
external usenet poster
 
Posts: 69
Default 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