I have a data of names in say sheet1. The names on the sheet1 keep getting updated. I have a list of same names in sheet2 but i want to get the new names which gets added in sheet1 to get automatically pulled to sheet2. Can anyone help me to get a excel function for it.
IF sheet 1 contains the names stored on A1, A2, A3 etc
Than sheet 2 should be
A1 =SheetName!A1
A2 =SheetName!A2
Etc etc
Hope it will work.
I simulated the problem in file. Is that what you want. Sheet 2 pulls the names in Sheet1
Appreciate the help? CLICK *
Hi AZ-XL
Thank you for your response.
But my query is if I add a new unique name in sheet A then that name gets automatically pulled in sheet B but if the name inserted is similar to the names earlier names then the name will not get pulled to sheet B as it is the repetative name. Can you suggest something for this
Actually my file does what yoou want. Try to add new name to Sheet1 and see the result in Sheet2. Column in Sheet2 takes only unique names what is inside that table in Sheet1.Originally Posted by vikash200418
Is there any special care which needs to be taken the file you have send contains array since the file would have other information as well. So will it affect them
For 100% I cannot say that it will not affect. Why dont you upload your file here. Or simulate it.
Okay AZ-XL,
The file is working as of now for me. Thanks for your help. I will add datas to validate for any error and will update you. Thanks once again
You are welcome. You may click star if you find my function helpful
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks