Hi,

i have created a list in sheet 1 and and the same list i have created in
sheet 2.. now if i add in sheet 1 list will the same gets updated in sheet 2
or in some other open workbook .. is there any way to do this without a VBA
code..?? any function which works on cell reference or range reference..??
--
amitwaze

in cell A1 of sheet 2 enter the formula

=if(sheet1!a1="","",sheet1!a1)

then copy this to however many rows and columns you want.

then as you add data on sheet 1, it will appear on sheet 2


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=565085