Reverse Copy/Paste using Index and Match

[Crackerjac]

Hello,

I am self taught in excel and in the wonderful world of Macros. My question is that I am building a database with a data entering sheet. I want to use the index and match in a reverse form. That it would find the location in a table and copy and paste the data enter into the cell on the data entering sheet to the that location in table on the other sheet.

I am doing a index and match to find the location as shown below:

Sub CopyMatch()


Sheet7.Range("C8") = "=Index(tblHoursD[[Lexington North]:[Chicoutimi]],Match('Info Sheet'!C19,tblHoursD[Year/Data],0),Match('Data Entering'!C7,tblHoursD[[#Headers],[Lexington North]:[Chicoutimi]],0))"


End Sub

But I want copy and paste the data in sheet7.Range("C8") to the location the the index and match.

I might be asking to much but if there is a way that would be great. If any questions please fill free to ask Thank you