Member Avatar for smnadig
smnadig 0 Newbie Poster

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

  • 1 Contributor
  • 0 Replies
  • 50 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.