Help Please-Linking Cells

**cglover89** · 12-20-2013, 02:25 PM

Hello Everyone,
I new here and I hopeful someone would be able to assist me. I am trying to link cells in one workbook across multiple sheets. I am aware of holding control button to group sheets but this is not a solution for what I am trying to do. Is it possible to have a workbook in which you can enter information in any sheet and have it populate in the other sheets.

Example:
Type in Sheet 1, changes in Sheet 2 and 3
Type in Sheet 2, changes in Sheet 1 and 3
Type in Sheet 3, changes in Sheet 1 and 2

The way I have it grouped now you must always enter in from the original sheet. Any help is much appreciated.

Thanks

**newdoverman** · 12-20-2013, 02:48 PM

This might be possible with VBA but would most likely produce Circular Reference errors if attempted with worksheet functions.

**FDibbins** · 12-20-2013, 02:52 PM

Hi and welcome to the forum

From what I can make of your request...you want to enter data in sheet1!A1 and it changes in sheet2!A1 and sheet3!A1 or enter data in sheet2!A1 and it changes in sheet1!A1 and sheet3!A1 etc?

If hat is the case, then no, this cannot be done with regular formulas. You can have either a formula in a cell, or an entry/text/value - you cannot have both.

However, someone maybe able to put together some VBA for you