Pulling data from one spreadsheet to another

Question

I have created a template in Word. I have been able to link the data needed to the template with one exception. I am trying pull a specific cell of data into another embedded spreadsheet in my template. Is there a way to do this?

This is the data spreadsheet I am pulling from:

This is the template, with embedded spreadsheet I am pulling to:

I need to pull the data from a cell in column G into the cell, which would be B3. Monthly price. I am able to get all of my other data into my template with this exception.

Answer 1

I am pulling all the data from the row and putting it into my template. I am unable to determine how to pull the data found in column G into the embedded spreadsheet in my template. I need the data (ie 325) to go into cell B3 of this spreadsheet. The column I'm pulling from for this cell is called Apr.

Answer 2

Hi RayB_57,

Thanks for visiting Microsoft Community.

Your requirement can be summarized as needing a formula to reference a specific cell in column G of Sheet2 into cell B3 of Sheet1. This is not difficult to achieve. The issue lies in how you uniquely identify the cell you need to index (monthly price)？. From the data source table, it appears that each column should have some kind of unique identifier, perhaps the Display Name column? If you can describe your requirement in more detail, I can provide you with a specific formula.

Best Regards,

Jonathan Z - MSFT | Microsoft Community Support Specialist