I apologize iof this is answered somewhere already, but I can't find it.
I'm using the info in a worksheet to populate the cells in another. I use the appropriate formula to reference the worksheet ie. =Sheet1!A46. It works in some cells but in others it simply displays the formula itself. The cells are formatted the same whether it be text, number, currency, etc.
Any ideas would be greatly appreciated.
Bookmarks