Inbuilt form in excel to be linked to other sheet/workbook

8-8-2013 5-29-25 PM.jpg

Hi,

Excel has an built-in form function which enables us to have data entered in excel using the form.

My query is that can we keep the form in Sheet 1 of the workbook and link the data that is filled in that form to some other sheet / workbook?

I tried to do it but couldn't find a way.

I have attached an image which can help you understand my question better.... hoping a quick and helpful response.

I wanted to know if this is possible or not.....