Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated Question
Well this isn't a complicated question, but it is for me. When I type text into a cell, I want the text to appear in another worksheet and in the cell of my choosing. How do I do this? Thanks. -- kyrospeare ------------------------------------------------------------------------ kyrospeare's Profile: http://www.excelforum.com/member.php...o&userid=33888 View this thread: http://www.excelforum.com/showthread...hreadid=536654 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated Question
Assuming you are typing into Sheet1, then in cell A1 of Sheet2 enter
this formula: =IF(Sheet1!A1="","",Sheet1!A1) You can copy this across and down Sheet2 to suit. Whatever you enter into Sheet1 will be mirrored in Sheet2. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated Question
Hi!
If you enter some data in cell A1 on Sheet1 and you want the same data to be entered in cell X100 on Sheet20, enter this formula in cell X100 on Sheet20: =Sheet1!A1 If no data has been entered in cell A1 on Sheet1 then the formula will return 0. If you don't the 0 to be returned then use this formula: =IF(Sheet1!A1="","",Sheet1!A1) Biff "kyrospeare" wrote in message ... Well this isn't a complicated question, but it is for me. When I type text into a cell, I want the text to appear in another worksheet and in the cell of my choosing. How do I do this? Thanks. -- kyrospeare ------------------------------------------------------------------------ kyrospeare's Profile: http://www.excelforum.com/member.php...o&userid=33888 View this thread: http://www.excelforum.com/showthread...hreadid=536654 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated Question
Thanks a million to both of you. -- kyrospeare ------------------------------------------------------------------------ kyrospeare's Profile: http://www.excelforum.com/member.php...o&userid=33888 View this thread: http://www.excelforum.com/showthread...hreadid=536654 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated Question
I tried entering =IF(Sheet1!A1="","",Sheet1!A1) but it didn't work. The formula just stayed in the box as if it were text to be printed. The exact formulas I tried we =IF(Sheet6!C35="","",Sheet6!C35) I also tried: =Sheet6!C35 I get nothing. The formula just stays in the box. Thanks. -- kyrospeare ------------------------------------------------------------------------ kyrospeare's Profile: http://www.excelforum.com/member.php...o&userid=33888 View this thread: http://www.excelforum.com/showthread...hreadid=536654 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated Question
That cell is probably formatted as TEXT.
Change the format to GENERAL, hit function key F2, then hit ENTER. Biff "kyrospeare" wrote in message ... I tried entering =IF(Sheet1!A1="","",Sheet1!A1) but it didn't work. The formula just stayed in the box as if it were text to be printed. The exact formulas I tried we =IF(Sheet6!C35="","",Sheet6!C35) I also tried: =Sheet6!C35 I get nothing. The formula just stays in the box. Thanks. -- kyrospeare ------------------------------------------------------------------------ kyrospeare's Profile: http://www.excelforum.com/member.php...o&userid=33888 View this thread: http://www.excelforum.com/showthread...hreadid=536654 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated SUMPRODUCT OR SUMIF question? | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Complicated question... | Excel Worksheet Functions | |||
complicated sum formula question | Excel Worksheet Functions | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) |