Retrieveing data from one worksheet/workbook into a userform of another worksheet/workbook

Hi All,

I am new with this vb coding. I am having problem with this particular issue of retrieving data from one excel sheet into a userform built into another workbook.
To explain elaborately, I have a main workbook/sheet where all the data gets stored via a userform. These data come from different woorkbooks/sheets and needs to be updated into the main workbook/sheet on a daily basis. The format of the data in these subsidiary sheets is same as that of the main workbook/sheet.

I would like to know, how do i get the data extracted from the subsidiary sheets into the userform of the main workbook/sheet and then with/without editing the data is input into the main sheet.



Thanks.

which versin of excel are you using?

excel 2007