I'm sorry I made a typo which might be confusing. My FYI should have said there were unnecessary references to Data2!A2 (for example) in the Data2 sheet. The sheet name doesn't need to be referenced when refering to a cell within the sheet the formula is in... Anyway you know all that.