Making a script

[PBSF Official Moderator]

Hello! I need some assistance. I am working on making a scripted set of columns for work. Lets say the scripts take up individual cells from A3 to A7. I am trying to find a formula where I can put an individuals name in a cell, say A2, and it will populate the script with their name in predesigned locations. 

For example. In A3 I may have "Hi, my name is John. It's a pleasure to be speaking with you (insert name here). How can I help you today" and in A4 I have "Thanks so much for the information (insert name here). I'll be happy to help with that" I want to be able to put in A2 "Jessica" and have it populate the designated spaces for a name. Please and thank you!

[#2]

Hi PBSF

Simple formula

="Hi, my name is John. It's a pleasure to be speaking with you "&A2&". How can I help you today"

please see attached file how you could solve it in few ways 

[#3]

i would like to code for following data in worksheet "Data" with scripting dictionary, where no. of students may increase.Also ouput the dictonary data to other worksheet "Output".

| Name   | maths | science | lang | history |
|--------|-------|---------|------|---------|
| pandit | 78    | 78      | 57   | 67      |
| sushil | 44    | 70      | 67   | 79      |
| kiran  | 48    | 55      | 57   | 67      |
| manoj  | 78    | 79      | 67   | 69      |
| kumar  | 78    | 52      | 80   | 74      |
| ranjit | 56    | 61      | 63   | 57      |

thanks