Replace data in a sheet (same workbook)

Jenina

Hello - 

I am trying to replace the data in Sheet1 from Sheet2 range A2:B6.

I used the formula tool: Replace([FileName], "`Sheet2`", 'Sheet1$A21:B60') 

Change entire file path to Full path.

But I am still not getting it, looks like I am missing something.

Thanks for the help.

Book3.xlsx

alexnajm

Is the formula above doing the Replace function? It looks like you might have extra apostrophes around Sheet2 that I am thinking is not making the Replace function work