Hi All. I am working in Excel2007. I have a spreadsheet in which i summarize mtd in my fields. One of the fields that I am pulling from changes every day. How do I pull the numbers into the field and keep the previous figures for a running total? Ex. may 1st has 3 and the mtd has 3. may 2nd changes to 2 but I want to capture that number plus keep the 3 for a mtd=5.
I hope I didn't confuse anyone.
Thanks
I hope I didn't confuse anyone.
Thanks