Hello,
I am trying to link two spreadsheets together where I input data into one and then have it copied into the other. I am using a Mac and simply using the following formula;
='[Other Workbook.xlsm]Sheet1'!$C$3
It works fine enough for when I have numbers and dates in the other file but when it tries to copy over a cell with text in it, it just shows the formula above in the cell. How do i set the formula to pull through the text in the other file and not just show the formula to get the data?
I know that I can use VBA to link the two together and transfer the data but if this simple version above can work, I would prefer to use that.
Thanks in advance
I am trying to link two spreadsheets together where I input data into one and then have it copied into the other. I am using a Mac and simply using the following formula;
='[Other Workbook.xlsm]Sheet1'!$C$3
It works fine enough for when I have numbers and dates in the other file but when it tries to copy over a cell with text in it, it just shows the formula above in the cell. How do i set the formula to pull through the text in the other file and not just show the formula to get the data?
I know that I can use VBA to link the two together and transfer the data but if this simple version above can work, I would prefer to use that.
Thanks in advance