I have two worksheets, one of which is a shorter version of the first. For
example, let's say I have 12 columns in W1, and 9 columns in W2 which have
the same data as W1. In other words, W2 uses 9 columns from W1, but not
necessarily 1-9, it could be the 1-6, 8, 11, and 12 columns from W1.

So the data from W1 is to move to columns in W2 as follows:

W1: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
W2: 1, 2, 3, 4, 5, 6, x, 7, x, x, 8, 9

The above is only an example, but the point is that I am not copying a block
of columns from one to the other worksheet, as some of the columns to be
copied skip a few from the original that I do not want copied.

What is the basic procedure that allows me to work with W1 and have the data
entered also be entered from W1 to W2 without me having to go through a
tedious copy/paste process?

Is this synchronization?

I hope that the above explanation is clear enough.

Thanks
Lewis Shanks