From thread: http://www.excelforum.com/excel-new-...ple-cells.html
I put this VB code into my Workbook and all of the cells that I want to accumulate are doing just that. But, I also want to link these cells to another workbook. When I go to put the formula to do this into the respective cells, the number updates, but the formula does not stay in the cell so the next time the number is changed in the other workbook it will update. What is going on? Is the VB code causing it to do this, and is there a way to fix it? Thank you. Hope I did this correctly now, I started a new thread as asked, I'm new at this and really appreciate all the help I have recieved so far.
Bookmarks