I have a formula in cell a1 in sheet b, but I just want the value in sheet c. I am using this method =b!a1. How can I do this to only bring over the value and not the formula?


You could use an array to pull the data from one sheet to another sheet.

={b!A1:A} this will bring the whole column from sheet B.

For the value only you will need to copy and paste with values only. This can be done with a recorded macro if the data is updated in sheet B.

Using { } to create arrays is great way to import whole columns of data between sheets.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.