Select all the target worksheets and just enter it on the visible one.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"create_share" wrote in message
...
Is there a way to enter data at the same time on multiple workbooks like
worksheets. It is very difficult and time consuming if you have multiple
workbooks having the same data but you can't enter data on them at the
same
time.

i don't want to combine these workbooks in one workbook because of some
reason.

any help?