re is a macro that then can take the data in certain fields across multiple worksheets and sum it into one cell.-- CheckSite.us | YourIP.us | Reverseip.us actions ?? 2013-Mar-2 8:18 pm ?? bbear2Premiumjoin:2003-10-0694045kudos:5Reviews:??VOIPO bbear2 reply to Rob reply to Rob Rob, You didn't say which version of Excel you are using so I am going to assume 2010 and let you take it from there.