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?
Google-sheets – In a Google spreadsheet I want a cell in sheet c to grab a value in sheet b without grabbing the formula
google sheets
Related Solutions
You need to use the indirect() formula. So in cell B1 you need to put this formula:
=indirect(A1&"!B4")
There is not normally any difference between sorting on values as such or sorting on the results of formulae. Column A shows the result of applying weekday to the chronologically entered values in ColumnB. D:E is a copy of A:B but sorted on Column D ascending.
There may be issues however with certain formulae that use the likes of Row() or offset, in which case it would help if your Q specified or gave an example of such formulae.
Related Topic
- Google Sheets – How to Check if Value is Given in Cell
- Google-sheets – How to show cell data as a value when referencing another cell that includes a formula
- Google-sheets – Trigger when a cell value changed by formula
- Google-sheets – How to get the SUM total value to appear in cell vs the formula
- Google-sheets – How to change the formula of one cell based on the value in a different cell
- Google-sheets – Google sheet showing #VALUE! error for non-formula cell
Best Answer
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.