I searched and found this thread and this is on the right track: http://www.excelforum.com/excel-new-...that-cell.html
However this is a same cell reference what I need to do is as an example have a data value to into Cell A1 and then it would copy to A2.
From this point every time every time I add new data to A1 it would take the previous value of A2 and add the new data.
Efectivly:
A2 = A1+A2 where A2 can retain a value so that it can cummilate data over time.
I know its easy but I am just not a VB guy.
I like how Post#3 works in the linked thread I just coulnt quite figure out how to make it work for me.
Also this same effect is going to be used multiple times on a single spreadsheet so the easier it is to extend the code the better.
Thanks Guys,
Bookmarks