Creating a Master Worksheet

[MattJ]

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...

[Richard Buttrey]

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...

I'd be inclined to use an Advanced Data Filter, and make this the object of a VBA macro attached to the Worksheet Change event on the Master worksheet. The VBA macro would then react every time you changed the master sheet, or perhaps preferably you'd make it run when you click a button object so that it populates your three price lists.

HTH

[royUK]

Tools >-Options>-View & de-select Zero values, will hide zeros.

If that isn't what youu want attach a small example of your data & how you want it laid out.