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.
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
@alexnajm I tried removing the extra ones but still not working, looks like it won't accept my range.
Can you send over the before and after result of your formula?
@alexnajmalexnajm
It's returning an error 'sheet1$a21:b60$ is an invalid sheet range specification for excel
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!