I have several questions, because I am an Excel learner. No expert.
On Sheet1, I'm using the function/formula ='Sheet2'! along with the cell number I'm trying to pull info from and pulling it into a cell on Sheet1. If the Sheet2 cell is blank, why is it pulling a zero into the cell on Sheet1. What do I need to do to keep it blank?
Also, if a cell from Sheet2 has something in it and I want it changed to an X on Sheet1, how do I accomplish that?
Last question, if I want to pull information from a range of cells on Sheet2 into one cell on Sheet1, can I do that?
Thank you for the reply! Question 1: I didn't get time today, but I will try this. Questions 2: yes, Sheet 1, is a work order and X's a box for a specific machine process Question 3: Usually, the range of cells I'm pulling from only has something in one of the cells, so it wouldn't be pulling info from multiple cells...just looking at which one to pull from...I hope that makes sense.