LinkBack URL
About LinkBacks
Hi,
Can anyone help on Excel functions. Say example I have name column (A2:A) in sheet1. When ever I update the column (A2:A), the name column (C2:C)in sheet2 should update automatically . Can anyone help.
Regards,
Rajesh
Hi,
Can anyone help on Excel functions. Say example I have name column (A2:A) in sheet1. When ever I update the column (A2:A), the name column (C2:C)in sheet2 should update automatically . Can anyone help.
Regards,
Rajesh
I'm sorry, but you are going to have to explain in more detail what you are trying to do.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Sheet1
Name.
Aa.
bb
Cc
Sheet2
Name
Whatever I update in sheet1, it should automatically change in sheet2 name column.
Regards
Rajesh
I see. So, in C2 dragged down:
=Sheet1!A2
Is this what you want?
If you are going to be inserting and deleting data in Sheet 1, try this:
=IF(LEN(Sheet1!A2)>0,Sheet1!A2,"")
Last edited by AliGW; 10-18-2018 at 02:37 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks