RSS Forums RSS

Problem transfer data across worksheets

Please support our Windows Software advertiser: Programming Forums
Reply
Posts: 11
Reputation: smnadig is an unknown quantity at this point 
Solved Threads: 0
smnadig smnadig is offline Offline
Newbie Poster

Problem transfer data across worksheets

  #1  
Nov 19th, 2008
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
Thanks & Regards
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Similar Threads
Other Threads in the Windows Software Forum
Views: 301 | Replies: 0 | Currently Viewing: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 2:49 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC