cells that equal each other regardless of which is filled first

[cheddarthief]

Is there a way to make cells in different worksheets withing a workbook equal each other regardless of which cell is filled in first? Let me see if I can clarify my question.

Sheet 1, Cell A1
Sheet 2, Cell B2
Sheet 3, Cell C3
etc.

I want that no matter which tab I start off with, when I fill in one of the above noted cells, the other cells will match as well.

Jim

[StephenR]

Might be a quicker way, but try this in the workbook module.

Please Login or Register  to view this content.

No idea if this is any more efficient, but seems to work.

Please Login or Register  to view this content.

[cheddarthief]

That's an effective method except I usually copy dozens of worksheets within the same workbook and then I would have to go back and update the code for the number of sheets. I was hoping there was some sort of value that could be added to the cell to accomplish this; one that when I copy the template sheet, it intuitively updates the formula for the new sheet.

Jim

[cheddarthief]

Maybe I wasn't clear on my first posting. I have RFQ workbooks that have multiples worksheets in them. The worksheets are all basically the same with the exception of some customer variables. I need some of the cell numbers (they are the same cell numbers in all sheets) to have the same information. For example: Date, Project #, Reference #, Bid Date, etc. I'd prefer to not type this in the dozens of worksheets but rather type it in the first and have it populate the others. OR if I'm in the 5th worksheet, type the information there and have that cell populate the rest. This can't be the first time someone has heard of this request. Any ideas?

Jim

[cheddarthief]

I'm surprised, I thought this would be a relatively common need but no one seems to know the answer to this one.