=, match or ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have changes on one worksheet to automatically & identically take place on another one within the same workbook, including cell formating, sorting, etc..
Help!!!
Thank you in advance
JJEC
 
you can use the following worksheet method:

Workbook_SheetSelectionChange. with it u can check if a
cell within target (a paramater of this function) was
changed and if so copy the changed cell to the desired
sheet.
if you want to check if there was change or not, every
time a range selection is made (whether it is one cell or
more) you should copy the cell to another location (say
another sheet) so that you'll be able to compare it's
value after you leave it.
If i'll find less complicated way i'll let you know.

tal.

-----Original Message-----
I need to have changes on one worksheet to automatically
& identically take place on another one within the same
workbook, including cell formating, sorting, etc...
 
Hi
though it's not a problem to 'copy' the value of your cell (just use a
simple formula) this is complicated for formats, etc.:
- you may use the worksheet_change event. This is triggered if the
vsalue in a cell changes. You could use this to also transfer the
formats of the source cell
- Drawback: This event is NOT triggered if you only change the format
of your source cell. E.g. if you change the color of your source cell
the target cell in the other worksheet is NOT changed.

Another way would be to use the workbook_Beforeclose or
workbook_beforesave event to copy the cell contents before
closing/saving the workbook.

So no easy solution for this topic
 
Back
Top