Link to home
Create AccountLog in
Avatar of route217
route217Flag for United Kingdom of Great Britain and Northern Ireland

asked on

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.
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

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.
Avatar of route217

ASKER

Thanks for the feedback. So its not possible to have a formula that ignores values..and only adds data to blqnk cells
That's correct.
What options do i have?
SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks for the excellent feedback