Thread: [Solved] Copying a Changing cell value to one cell
View Single Post
 
Old 04-29-2014, 11:21 AM
mbesspiata mbesspiata is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default Copying a Changing cell value to one cell
I have a report where I have the total of ins and outs for the month but I want to show the last months total ONLY in one cell p8. I will use that one cell for calculations in another sheet in the workbook. How can I have one cell show a value that will move from c9 to n9 over the course of a year? Cells c7 and c8 will be totaled to c9 and I need that value to show up in p8 but each new month the total will need to move to the cell to the right.

Mike
Reply With Quote