Via code, making 2 named Ranges Indentical, upon change
Hi,
Here is a good one I have been pondering for a while, still, in all my
efforts, I have not gotten what I really need. I am not an Excel-VBA expert,
so I am hoping somebody in here can give some insite.
OK, unforunately, there is no row insert/delete event..WISH LIST
I have 2 seperate named ranges; if I change one, I would like the other to
change and look exactly the same as the one that I just changed.
That means, if I delete a row in one, then I want the other to delete a row
and update all the values in the cells to match precisely. Same if I add a
row.
I hope this makes sense and is this possible?
If may work on a Change event but it is not necessary really; if I change
one, then I don't mind clicking a macro to update.
Thanks in advance!
ML
|