(Close Window) 
Topic: Excel Help  This is a good one I think 


To me the answer lies somewhere in the question but I can't piece it together unless it can not bo done through a Function. Example Same Workbook Worksheet 1 Cell A:1 IF someone enters a value (numeric or text) I want that same value to appear on Worksheet 2 in Cell A:1 It's driving me nuts and I know nothing about macro or whatever the other one is VBA? 


On Sheet2, type an equal sign in cell A1, click the Sheet1 sheet tab, click cell A1, and then press Enter. Your formula in cell A1 on Sheet 2 should look something like =Sheet1!A1. You could also just type the formula =Sheet1!A1 directly into the cell on Sheet2. Curt 


...and that's how you get your sheet together in Excel. 


If you want the cell on Sheet2 to be blank when the cell on Sheet1 is blank, you'll need to go a bit further: =IF(ISBLANK(Sheet1!A1),"",Sheet1!A1) If you just use =Sheet1!A1 then when the cell on Sheet1 is blank, the cell on Sheet2 will have a zero. 


I personally prefer a zero if a value is suppose to be in a cell. 


I like IF statements... 


Thanks a million guys I appreciate the help. This will make our 6Sigma data entry work a heck of a lot more stream line. 