Forum Discussion
REF! error on formula cell when new order data is pasted into reference cells
I am creating a order tracker for an aerospace manufacturing department and I have run into some issues.. I get the REF! error on formula cell when new order data is pasted into reference cells. T...
Since you are using data on different worksheets, you must mention the worksheet name before the range such as this: =Sheet1!A1
Sheet1 is the worksheet name then ! before the cell or range name
I forgot to mention that in the above, apologies
My formula does however contain the sheet name.
I was thinking maybe I need to use the "INDIRECT " function in my formula 🤔
Do you think that would overcome the issue?
