• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating copy of cell automatically

A

ashish navale

New Member
Hi,


I need a technique through which excel will automatically create the copy of data I entered in particular cell.

Eg. If I enter 50 in cell A1, excel should create the copy and automatically enter 50 in B1 cell. Again when I edit cell A1 and enter another number it should copy that number and add up with previous copied data..

Suppose I enter 50 in cell A1, that cell will be copied in B1. Then again I delete cell A1 and enter 100. This time B1 should show 150. Is this possible. I know my expectations are very high :)..but I think you experts will definitely have some solution. Please help me with a technique without Macro.
 
Ashish,


This is not possible without a macro...


And this has been a recent article on DailyDoseOfExcel... see the link below and use the last code in the comments area of the article.


http://www.dailydoseofexcel.com/archives/2011/11/30/udf-for-cumulative-sum/


~VijaySharma
 
Hi Vijay,

Could you please guide me as how to prepare this macro. Because when I did using following steps it did not worked..

Open Excel--Alt+F11--Insert-Module

Then I copied the last code which you said. I saved the file first in normal way. I didn't worked. Then I saved as Macro enabled template. Still not working. Could you please guide.
 
Ashish,


Can't this be done with Formulas


B1: =A1

B2: =If(A2<>"",+B1+A2,"")


Copy down
 
You must log in or register to reply here.
Back
Top