I know that excel has a function that allows you to create a data connection
to sharepoint to create a live feed. Is there a way to programatically export
data from excel into a sharepoint list with the same fields.

I created a simple macro to select and copy a aset of cells, now I would
like to take it one step further and have that macro paste the data to a
sharepoint list, new row item. Is this possible?