Transfer data from userform to a seperate workbook

[sn152]

Hi All,


I have a userform in which when I enter the data and click submit, it gets transferred to sheet5. And when I enter the Emp Id and click retrieve button it pulls the data from sheet5. But what I want is, I want the data to be transferred to a common workbook which is saved in a common path.So that everybody can save the data there. For example I want the data to be transferred to the workbook "Report.xlxs" which is saved in the path "D:\Data". Please help me with this... I have attached the sample file.


Thanks in advance....

[Tinbendr]

Will the columns be the same in the Report.xlsx worksheet as in sheet5?

Does the EmpRecord need to be updated in Report.xlsx, or added to the bottom of the column?

Can the path to D be hard coded? Or will you need to navigate to the file?

Is there a chance that the file will be in use when it's updated?