Dynamic Cell Linking... maybe?


Hello all!

I have a template setup with various columns holding information that I pull from another sheet. The information is project specific and I currently copy/paste the information to the template and save it as the location name. My question is if there is a way to automate the creation/population of the template.

For example, I would like the information in the below columns;

To populate into the appropriate cells on my template;

Short of a vlookup, which wouldn't work for formatting I don't think. I've run out of ideas.

Thanks anyone for any ideas!


  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭


    Normally I would recommend researching INDEX and COLLECT.

    I use them together to pull data from one source sheet into a target sheet based on a key value in a column in the target that is compared to the matching source column.

    I'm not sure of the implications of trying to do so within a template. I suspect the formulae won't be able to discern sheet names properly.