I've made a master worksheet that I want to use to transfer data to other worksheets. Ive set up the following:

Master pricelist
Pricelist 1
Pricelist 2
Pricelist 3

On Pricelists 1-3 I need the data from the master to be identical except for one column.

I know I could just copy the master, but it wouldn't update as I change the master.

Now also I know I could (= Cells in Master) in all the cells in the Pricelists 1-3 but that leaves me with a heap of 0s in the places there are blanks. I don't want these.

I know I could just erase these 0s on the Pricelists, but if I need to add to the master in that position, it wont copy across.

I might also need to add a row to the master in the future, how do I set up the Pricelists to also reflect this change.

Any help you can give is greatly appreciated...