Updating List

[amitwaze]

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

[robert111]

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