Hi there I have an issue with one sets of data for three different workbook, and they are saved as three different names, but data i have is used to calculate results for each different workbook criteria, is there a way of using the Name Function in excel and defining the name to use as one criteria for use of all three. I have tried many different ways but to no avail, is there anyone out there, who may be able to help me with simple problem, husfay