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.

[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

[Jenina]

@alexnajm I tried removing the extra ones but still not working, looks like it won't accept my range.

[alexnajm]

Can you send over the before and after result of your formula?

[Jenina]

@alexnajmalexnajm

It's returning an error 'sheet1$a21:b60$ is an invalid sheet range specification for excel 

[alexnajm]

I’m not at my computer right now, but the path should look like “…output.xlsx|||Sheet1$A21:B60”

if it looks different, please show us the value so we can look further!

[Jenina]

@alexnajm 

Yup it looks like that.

Thanks