Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct copying blanks or how to insert zero into blanks | Excel Worksheet Functions | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
replace blanks using formula | Excel Worksheet Functions | |||
USING IGNORE BLANKS IN FORMULA | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |