Forum Discussion
select values from other sheet and paste into bunch of texts in between
Hello All,
I am new space and looking to automate one task where I need to replace values in between texts which is coming from different sheet. I managed to update values between sheets using "vlookup" function , but here , my requirement to pick values among texts and replace from different sheet.
In given below text , I want to select values from other sheet and paste into the sheet which is in between "double quotes
"We have received confirmation from zylo team to move to ZDS environment. This requirement is for "Test ISA permanent test environment" after migration. DDBA to update for Table compression details.
Regards
5 Replies
Hi AlokBeheria,
if I understand you right, you want to mix static text with dynamic text. If that's the case, you have to enter the static text starting with = sign and double quotes. And then you can concatenate it with any type of formula, cell reference etc. by using the ampersand sign &
Here is one example that just pulls another text from cell A1 in Sheet2:
="Hi L3 Support, we have received confirmation… This requirement is for "&Sheet2!A1&" after migration. DDB to update…."
- Martin_Weiss Thanks for your help here , but it seems , I am still not out of the woods and in order to make your suggestion , I have to put "= + entire text in one line" , otherwise , it's not working for me.
I need the text to be aligned in multiple lines. Also, if I change the values from source text, it's not reflecting straightaway as it reflects in case of "vlookup" and I also want if someone change this text , it should immediately reflect on reference sheet. Since , I am not allowed to paste pictures, I am not able to explain it effectively. Hope , you able to make out from my question.
Regards- Any inputs from your end mate. I would appreciate , your help here.
Regards
