|
|
x-treem Inner circle 1133 Posts |
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?
A direct from text adaptation : The Strange Case Of Dr. Jekyll & Mr. Hyde Starring Mickey Rooney in his final role.
|
cfrye Special user Portland, Oregon, USA 940 Posts |
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 |
Scott Cram Inner circle 2678 Posts |
...and that's how you get your sheet together in Excel.
|
S2000magician Inner circle Yorba Linda, CA 3465 Posts |
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. |
MagicSanta Inner circle Northern Nevada 5841 Posts |
I personally prefer a zero if a value is suppose to be in a cell.
|
TomKMagic Special user I tripped over 620 Posts |
I like IF statements...
|
x-treem Inner circle 1133 Posts |
Thanks a million guys I appreciate the help. This will make our 6Sigma data entry work a heck of a lot more stream line.
A direct from text adaptation : The Strange Case Of Dr. Jekyll & Mr. Hyde Starring Mickey Rooney in his final role.
|
The Magic Cafe Forum Index » » Not very magical, still... » » Excel Help - This is a good one I think (0 Likes) |
[ Top of Page ] |
All content & postings Copyright © 2001-2024 Steve Brooks. All Rights Reserved. This page was created in 0.02 seconds requiring 5 database queries. |
The views and comments expressed on The Magic Café are not necessarily those of The Magic Café, Steve Brooks, or Steve Brooks Magic. > Privacy Statement < |