Need to combine data from 3 spreadsheets

[iiser1024]

Hi,

I am a chemical engineer, and working on a plant which generate results after an hour.

It generates two excel sheets from which I convert the results in different units. Then I need to paste these values in another template I have created which combines the data from the last two excel sheets.

After that I need to paste these values(results) in final excel file which gives me the results as a function of time and I get results in graphical format as well.

But it involves a lot of time in copying and pasting, so I was wondering if we can use macros to combine the data automatically.

I know little about macros but have a good knowledge of excel 2007.

Thanks in advance.

Cheers,
Prakhar
(INDIA)

Trust the art, not the artist

http://www.excelforum.com/editpost.php?do=editpost&p=2588247