Kiba,
i am working on a worksheet of tracking of container nos on sheet1 as
displayed
x sr.no container no. bla1 bla2 bla3 bla4 bla5 bla6 bla7 bla8 bla9
blla10.....to bla53
x 1 pciu..
x 2
x
x 8600
x x x x x x x x x
Now, some of the rows remain unchanged which cud be updated at once by
copying external data to it. suppose containers are loaded in x-vessel,
vessel name is update at once for all containers. on daily basis had to
update bla15 bla52 bla35 therefore instead of updating 8600 colums & 53 rows,
i wanted to update the same data in sheet2 as mentioned below.
x contianer no ----
x
x bla1 x bla16
x bla2 x bla19
x bla3 x
x
x
x
x
x
x
x x x x x x x x x x x x xx

as mentioned above we will type the container no and the sheet2 will display
all the contents of container no. from sheet1, i can link both the sheets but
how can we update the data feeded on sheet2 into sheet 1.
pls urgently reply on the matter and enable me to produce a presentation for
my collgues.

"Kiba" wrote:

Ok So I have a worksheet, currently it has a macro that copy and pastes data
from the master sheet to several other worksheets. Some of the sheets are
hidden and inorder to copy and paste to them when the update button is
pressed I have to un hide and re hide. Is there a way that I can link cells
so that they can update when button is pressed without unhiding?