Three cells with the same value all the time

[McLareNas]

hi, i have problem...

lets say i have three cells ranges (A1:A100,B1:B100,C1:C100). I want them to be the same value (A1=B1=C1, A2=B2=C2,...) and to update after changes automatically doesn't matter which one (A1, B1 or C1)i change. I googled a bit and i found that macro can do that, but the given examples was not enough. So maybe someone could help me?

[Darzou]

Hi,

Please Login or Register  to view this content.

Regards,

Darzou

[jeffreybrown]

Hello & Welcome to the Forum,

Try...

Please Login or Register  to view this content.

Paste code in a Sheet module

• Where to paste code
• Highlight macro to copy >> Ctrl + C >> Open your workbook
• Right click on sheet tab >> View Code >> opens the Visual Basic Editor (VBE)
• Ctrl + R >> opens the Project Explorer (if not already open on left side of screen)
• Paste code >> Ctrl + V (right side of screen)
• Alt + Q >> exits VBE and returns to Excel
• Now simply make a change in target cell

[Marcol]

Or maybe this

Please Login or Register  to view this content.

Or this variation of Darzous' code

Please Login or Register  to view this content.

[McLareNas]

i used jeffrey's code, its working. Thanks. But...

What if i would like to have 4 equal cells? I mean maybe you could explain what is exactly happening in Select case part. I want understand the code and manage to change it myself when i want

[Marcol]

That's why I offered the last two solutions, just change the width of the range.
Change Range("A1:C1000") to Range("A1:D1000") or whatever. The first column needs not be "A"
The rest of the code is based on the range position and dimensions.

[McLareNas]

Thanks guys but i have one more question. Rather similar but more difficult. Hope its possible to do that.
I have this worksheet https://dl.dropboxusercontent.com/u/...6/problem.xlsx

Here we have sports results in two different tables. Left one is in groups, right is done according to a schedule. Similar like in previous situation i want to have the same value all the time in "Score" columns. Right table is made with index-match function (same as vlookup). So for example i want that values in cells J33 and V12 would be the same. But if i change number (column D) do a different value, right table should also catch its correct value. In a worksheet score is with index-match function but it should just a value. The main idea is that i want to able to add result to each of those two tables and no needing to correct anything after that

[jeffreybrown]

Hi McLareNas,

As this question seems as it will differ from the original, please start a new thread.

Also, it would be better if you attach your file here on the forum as some people may not be able to reach the site you reference, and therefore, could potentially narrow the scope of help you could receive.