Formula to append new data and keep existing data

route217
route217 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
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.
route217Junior

Author

Commented:
Thanks for the feedback. So its not possible to have a formula that ignores values..and only adds data to blqnk cells
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
That's correct.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

route217Junior

Author

Commented:
What options do i have?
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
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".
Finance Analyst
Commented:
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.
route217Junior

Author

Commented:
Thanks for the excellent feedback

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial