Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.
I have a workbook with 2 sheets on one sheet called, Race 1 I have a cell L29.
On the other sheet called, Profit and Intro I have a cell E12 It gets its data from Race 1 L29.
I want to be able to reset the Race 1 L29 cell to '0' without it resetting the E12 cell, but rather leaving the data value as it is until I reset it another time.
Thank you for taking the time reading this.
2012-03-04 10:18:00
If you are using a formula in [Profit and Intro]!E12 such as =[Race 1]!L29 to do what you describe (getting its data from the second page), any time you reset the L29 cell, it will be immediately reflected in the other page. To do what you are describing for the reset action, you would need to create a macro to put the value into E12 when you want it there and another macro could be written to perform the reset operation. Let me know if this is what you want and I can provide the necessary macros to do it.
2012-03-04 11:52:00
Hello Bruce yes that's just what I need. That would be great if you could do that for me. thanks.And just one other thing when you have sorted it for me how do I close this thred? It's my first time here and I havent had to do that yet.Thanks again Bruce.Harry
2012-03-03 16:42:00
How to Write a Reset Macro for Excelhttp://www.ehow.com/how_4473387_write-reset-macro-excel.htmlCreate a Macro to Reset Cell Values in MS Excelhttp://www.techsupportforum.com/forums/f57/create-a-macro-to-reset-cell-values-in-ms-excel-529305.htmlExcel Create Command Button To Reset Cell Values?http://answers.yahoo.com/question/index?qid=20090218144209AAr3jwcExcel . Reset Button - ??http://help.wugnet.com/office/Excel-Reset-Button-ftopict1075863.htmlGetting Started with VBA in Excel 2010http://msdn.microsoft.com/en-us/library/ee814737.aspx