Move data to protected sheet

Sir

i have a sheet enabled with macro and codes but protected by all means by sheet protection and by vba protection

now my prob is in this sheet i use see my other excel sheet and feed the data from there

i want some how the data may automatically move to this protected sheet

but because of protection it hadnt..........

Sure, you protect to restrict such operations (by user or by code too). but always in the code you can:

Please Login or Register  to view this content.

I appreciate and thank you for the replies

my problem is that , i am using someone else workbook whose sheets and vba is protected

so i use to feed the req data manually

i want to automate the process to move data from my excel to macro enable excel

Sir

this amcro is provided by my comp and we dnt know the password

and every times we need to feed data from the sheet we prepare

its tedious so i was ...lets presume if intire sheet is protected..or i will take a sample from my office and attach you for the ref