How about a simple cell linking function?
Look at column A in Worksheet B as an example.
Link each cell in column A to the identical cell in column A in
worksheet A. Just do one linking formula in the first cell, then copy
down and across for all the other cells in the columns.
Don't forget to change the link for the 2 columns that are excluded in
worksheet B. (So columns A through K are identical in each worksheet,
but then column L in worksheet B will link to column M in workseet B.)
Since they are now linked, any changes you make to worksheet A will
automatically flow to worksheet B. Any changes you make to columns L
and N in worksheet A will be ignored in worksheet B, since you did not
link to them.


--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=500382