Forum Discussion

PBSF Official Moderator's avatar
PBSF Official Moderator
Copper Contributor
May 01, 2018

Making a script

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!

excel
Excel Online
Formulas and Functions

2 Replies

  • madhukar jadhav's avatar
    madhukar jadhav
    Copper Contributor
    Oct 15, 2018

    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

  • Tomasz Kocur's avatar
    Tomasz Kocur
    Brass Contributor
    May 02, 2018

    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