Reply to thread

Message: [QUOTE="aussiegirlone, post: 3237918"] I opened a new Excel workbook testing the code but I get N/A As another solution to my problem is to do something Stupid like this.... in cell D5 on sheet where copy of total will be =SUM(Employee1!AF:AF), then in Cell C5 =Sum D5/2. although its double the trouble I am getting a true result, otherwise, I don't know what else to do. It seems strange to me as the vLookup use to work but I noticed that every few days when I cleared the data on employee sheet this caused the vlookup to become a #REF# Anyhow, I think I'll just let it go! Thankyou all very much for all your help I do appreciate it. [/QUOTE]