copying data from one application to other

[jag134]

I have an Excel spreadsheet set up with a hyper link to Barchart.com.

I've been able to get a macro to open the web page, copy the data I want and paste it into a cell in Excel.

How do I get it to move to the next Excel line and repeat the process?

PS I have looked at dozens of macro programs and with your program I am moving beyond where I ever hoped to be.

[forumsupport]

Please refer to the following online example that is given as http://www.tethyssolutions.com/excel...s.htm#example1
This example is about how you can copy data from Excel to Word, field by field. Here it is explained by using Word for ease of explanation but you can copy it from or to any web form, application or database.
You can refer to this example and similarly automate your macro.