Hi All, I have say a worksheet that is calculating cells A1:A9 with the Total being displayed in cell A10
I want the answer of the Sum Function in cell "A10" to be copied to cell "A1" in a different worksheet named say "TOTALS" Easy enough but here is what I want to be able to do: When the data in the cells are used they will be "DELETED" at some point and then start all over again. When the data is deleted I WANT THE *COPIED TOTAL IN A1 ON THE TOTALS SHEET TO REMAIN!!!! * and then when new values are entered I want the "A10" value to be copied to the same *TOTALS WORKSHEET IN cell A2 (I don't want it to overwrite what was in A1 from the previous data * and then just continue to do so with all new data being entered.......next time put in cell A3 because of A1 and A2 are holding previous data totals. Is this possible? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
