Update Similar lists on multiple worksheets in the same workbook

[ron2k_1]

Hi crew!

Please help with the following, I know I have to use a Worksheet_Change event, but not quite sure how to draft it properly, I gave it a try and ended up in a bit of trouble, so, here I am requesting help from you professionals.

I have a workbook with several sheets, however, I have two worksheets [Comparison Detail] & [Comparison Summ]. These two worksheets have the same validation lists on Cell B1 and B2 [different validation lists on each cell by the way]. What I would want is that as soon as I change the value in either B1 or B2, that the other sheet (containing the very same lists) to update to whatever value I just changed to on the other sheet. Hopefully this made sense...

Thank you

Ron

[Marcol]

Have you tried simply entering the value in one table say A1 and in the other table in the coresponding position puthe formula =A1.

[ron2k_1]

Have you tried simply entering the value in one table say A1 and in the other table in the coresponding position puthe formula =A1.

Hi Marcol, thanks for the suggestion, but I don't want that.

It's my fault, I knew I had to specify that on my original post. Anyways, the reasons, why I don't prefer that is because I make selections on either worksheet and, and I want the other worksheet to return the same selection as it was done on the previous one. Therefore, if I use a formula, this will be replaced at the time I make a manual selection there.

Thanks though. Still waiting for some help on the code....

[ron2k_1]

Hi guys,

To show you that I am not lazy and just trying to take advantage of your knowledge for free, this is what I had, but is that not doing anything,

On "Comparison Detail", I have the following code:

Please Login or Register  to view this content.

and On "Comparison Summ", I have the following:

Please Login or Register  to view this content.

But its not doing anything.... Of course if you notice I don't have any code for cell B2, yet, not quite sure how to include it there.

Any ideas?

[Marcol]

Try this in the workbook module

Please Login or Register  to view this content.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

[ron2k_1]

Perfect!

Thank you very much, I'll definitely mark it solved and add to your help scale. You're good. I just changed the range to "B1:B2" instead of B12.

Thank you.

Out of respect, I need to appologize as this morning I posted a bit of similar question on another forum. My apologies, but I really thought that my post was being missed, sorry and thank you for proving me wrong. But nobody has worked on that other response yet, so I'll advise them there as well.