Thread: Excel help - Can I get excel to link cells?

G'day all,

I am not sure if what I am trying to achieve is possible in Excel.

I have attached a sample spreadsheet I made up. This is a hypothetical example to represent the output I'm trying to achieve.

• Sheet 1 is a list of Bicycle names vs forecast production numbers for the next ten years,
• Sheet 2 is a list of sub-assemblies required to produce each bicycle,
• Sheet 3 is a list of sub-assemblies vs forecast production numbers for the next ten years.

In sheet 3 I would like excel to tell me the total number of sub-assemblies required for each year, using the information derived from sheets 1 and 2. Some sub-assemblies are common to various bicycle types, some are unique. I am looking for a way to link the data in sheets 1 and 2 so I can hopefully auto-populate sheet 3. Is this possible?

Ultimately I would also like to be able to amend the figures in sheet 1 as needed and then have sheet 3 updated automatically.

I have searched all over google and the closest I can find is a discussion about one-to-many relationships defined using Microsoft Access databases. This is way above my skill level.

Any assistance would be appreciated,

Thank you in advance.

Hi vlady, thanks for your help! The output in your solution is not really what I'm after. For example, on Sheet 3 cell B3 I would expect the output to be 63. This is derived from the addition of (Sheet1:B3 * Sheet2:B3) + (Sheet1:B4 * Sheet2:C3) + (Sheet1:B5 * Sheet2:D3).

I understand I could just write a formula doing what I've just done for each output cell on Sheet 3. However in the actual spreadsheet I am working on, Sheet 3 contains 300 rows and 10 columns, giving 3000 individual formulae I would need to write. I was hoping there might be a quicker way for excel to automate this process. Any assistance with being able to achieve this would be appreciated.

But thank you for your time so far.

Regards,

Martin