Index Function
I am linking a range of one sheet to another.
I highlight the same size and shape of the data I want to link, and I click = then go back to the source data, highlight it, go back to the destination sheet, click CONTROL/SHIFT/ENTER.
It works but I get a lot of 0's.....How can I make it show blank cells instead of 0?
='\\177.177.1.14\Sales\Order Status 2018\[Jason''s Orders.xlsx]Jasons Customers'!$A$6:$M$94
thanks
|