Problem transfer data across worksheets
 

Hi All,

I have a table consisting in worksheet2(DataSheet) which has country list and in another worksheet1 i have a list which i am populating from the table DataSheet.

I require the list in Sheet1 to be updated automatically as I add data in Sheet2.

I am unable to achive this by using Data validation as an error pops up as "Cannot use reference to other worksheets or workbooks".

Can anybody suggest me how do I solve the above problem?
Is there a way to achive the same programatically in VBA?



Regards,
Sahana