(Close Window)
Topic: Excel Help - This is a good one I think
Message: Posted by: x-treem (Jun 25, 2010 01:19PM)
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?
Message: Posted by: cfrye (Jun 25, 2010 02:22PM)
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
Message: Posted by: Scott Cram (Jun 25, 2010 03:10PM)
...and that's how you get your sheet together in Excel.
Message: Posted by: S2000magician (Jun 25, 2010 03:40PM)
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.
Message: Posted by: MagicSanta (Jun 25, 2010 06:29PM)
I personally prefer a zero if a value is suppose to be in a cell.
Message: Posted by: TomKMagic (Jun 25, 2010 11:29PM)
I like IF statements...
Message: Posted by: x-treem (Jun 30, 2010 11:18AM)
Thanks a million guys I appreciate the help. This will make our 6Sigma data entry work a heck of a lot more stream line.