Hi Ill try explain as best I can - If I have all the information I need on
the first tab in my work book and I then need to split this information and
copy it into another 2 seperate tabs. If i then change any data written or
numbers on the first tab how can i make the inaformation automatically change
in the other 2 tabs so all info is eaxactly the same even thought its been
split up? I have tried paste special and it does not seem to like this

Any help greatly appreciated