Formula to append new data and keep existing data

Hi Experts using excel 2010

Is there a way to usw a formula to append new data to a column and not to over write data that is already in the column. I have use a look to populate column A. Now i want to add new values to column A whilst keeping the original values in cilumn A.
route217Asked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
In a separate column you can use this formula:

=IF(A2<>"",A2,YourFormula)

Copy down the column and then you can copy this column and paste as values into column A.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
I am sorry! A cell can only have either a value of a formula in it, not the both.
You will have to look for a VBA workaround.
0
 
route217Author Commented:
Thanks for the feedback. So its not possible to have a formula that ignores values..and only adds data to blqnk cells
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
That's correct.
0
 
route217Author Commented:
What options do i have?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
It depends upon your requirement.
You need to tell what you have in column A and how you would like to add values in the blank cells in column A.
Would be better if you can upload a sample workbook and mock up the desired output on another sheet, name it "After".
0
 
route217Author Commented:
Thanks for the excellent feedback
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.