Forum Discussion
spicegirl326
Mar 22, 2024Copper Contributor
REF! Error Please help
Used a formula to collect data when I copy the data to a new spread sheet I am getting REF! error. I have tried every which way to correct this and I am not understanding. I used the =LEFT(B2,2...
- Mar 22, 2024
Depends on what you'd like to have in another sheet. If values, when copy 135 cells with formulae, in another sheet Paste->Paste Special->Values
SergeiBaklan
Mar 22, 2024MVP
Depends on what you'd like to have in another sheet. If values, when copy 135 cells with formulae, in another sheet Paste->Paste Special->Values
spicegirl326
Mar 22, 2024Copper Contributor
Oh my goodness!! THANK YOU SO MUCH!! IT WORKED!!
- SergeiBaklanMar 22, 2024MVP
spicegirl326 , you are welcome