Update the opening workbook by import data from another workbook

[irwan]

hi all,

I have a problem, I want to update my 'characterization list' workbook automatically. Below the way my workflow to be;

1.Open main template workbook(name as 'summary') and I fill up a few row of data.
2.I want to insert the updated data from above mentioned workbook(summary) into another workbook(name as 'characterization list') by clicking one button inside the 'summary' workbook.
3.by clicking the button I can open the 'characterization list' workbook and update the new data info automatically in a new row.

please help me to find the solution. I have tried many times but still no solution :-(

 

[irwan]

I missing something to mention earlier. workbook 'characterization list' has many worksheets. I only want to insert the updated data into one respective sheet only(i.e worksheet 'info')