Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type data in one cell - and it automatically populates another cel
I'm looking for a formula (I think a formula, or some other way) whereby I
enter data in one cell on one worksheet and it simultaneously (or after a keystroke or two) fills in the same data in a cell that I select on another worksheet, all within the same workbook. E.g., I type in the name "Roger" in cell C3 on sheet 1. I would have previously set up a condition in a formula or some other way whereby anything I type in cell C3 of sheet 1 is repeated in cell D4 of sheet 2. In other words, Excel does the "copying" on-the-fly using my pre-determined cells, i.e., anything I type in C3 is automatically filled in D4 of another sheet I specify. -- Tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type data in one cell - and it automatically populates another cel
Tom
In D4 of sheet2 enter =Sheet1!C3 Another way is to enter an = sign in D4 then switch to sheet1 and select C3 and hit ENTER key. And one more...........select C3 and switch to sheet2, select D4 and EditPaste SpecialPaste LinkOKEsc. In all cases, D4 will get the above formula. Gord Dibben MS Excel MVP On Fri, 16 Mar 2007 16:08:10 -0700, Tom wrote: I'm looking for a formula (I think a formula, or some other way) whereby I enter data in one cell on one worksheet and it simultaneously (or after a keystroke or two) fills in the same data in a cell that I select on another worksheet, all within the same workbook. E.g., I type in the name "Roger" in cell C3 on sheet 1. I would have previously set up a condition in a formula or some other way whereby anything I type in cell C3 of sheet 1 is repeated in cell D4 of sheet 2. In other words, Excel does the "copying" on-the-fly using my pre-determined cells, i.e., anything I type in C3 is automatically filled in D4 of another sheet I specify. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type data in one cell - and it automatically populates another cel
To add to what Gord said, I often do something like this:
=if(isblank(Sheet1!C3),"",Sheet1!C3) That way, you won't get a 0 in the cell in which the formula resides when Sheet1!C3 is blank. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Tom In D4 of sheet2 enter =Sheet1!C3 Another way is to enter an = sign in D4 then switch to sheet1 and select C3 and hit ENTER key. And one more...........select C3 and switch to sheet2, select D4 and EditPaste SpecialPaste LinkOKEsc. In all cases, D4 will get the above formula. Gord Dibben MS Excel MVP On Fri, 16 Mar 2007 16:08:10 -0700, Tom wrote: I'm looking for a formula (I think a formula, or some other way) whereby I enter data in one cell on one worksheet and it simultaneously (or after a keystroke or two) fills in the same data in a cell that I select on another worksheet, all within the same workbook. E.g., I type in the name "Roger" in cell C3 on sheet 1. I would have previously set up a condition in a formula or some other way whereby anything I type in cell C3 of sheet 1 is repeated in cell D4 of sheet 2. In other words, Excel does the "copying" on-the-fly using my pre-determined cells, i.e., anything I type in C3 is automatically filled in D4 of another sheet I specify. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type data in one cell - and it automatically populates another cel
Thanks Anne.
I too often forget about warning posters of the zero issue and giving them a fix as you have done. Only drawback is a straight "paste links" won't add the error trap so you have to build the first formula from scratch then copy. Gord On Fri, 16 Mar 2007 23:19:46 -0400, "Anne Troy" wrote: To add to what Gord said, I often do something like this: =if(isblank(Sheet1!C3),"",Sheet1!C3) That way, you won't get a 0 in the cell in which the formula resides when Sheet1!C3 is blank. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Tom In D4 of sheet2 enter =Sheet1!C3 Another way is to enter an = sign in D4 then switch to sheet1 and select C3 and hit ENTER key. And one more...........select C3 and switch to sheet2, select D4 and EditPaste SpecialPaste LinkOKEsc. In all cases, D4 will get the above formula. Gord Dibben MS Excel MVP On Fri, 16 Mar 2007 16:08:10 -0700, Tom wrote: I'm looking for a formula (I think a formula, or some other way) whereby I enter data in one cell on one worksheet and it simultaneously (or after a keystroke or two) fills in the same data in a cell that I select on another worksheet, all within the same workbook. E.g., I type in the name "Roger" in cell C3 on sheet 1. I would have previously set up a condition in a formula or some other way whereby anything I type in cell C3 of sheet 1 is repeated in cell D4 of sheet 2. In other words, Excel does the "copying" on-the-fly using my pre-determined cells, i.e., anything I type in C3 is automatically filled in D4 of another sheet I specify. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type data in one cell - and it automatically populates another cel
:)
Were you in Seattle? If yes, I'm so sorry I missed you. I had a unique opportunity to crash and met so many others. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Thanks Anne. I too often forget about warning posters of the zero issue and giving them a fix as you have done. Only drawback is a straight "paste links" won't add the error trap so you have to build the first formula from scratch then copy. Gord On Fri, 16 Mar 2007 23:19:46 -0400, "Anne Troy" wrote: To add to what Gord said, I often do something like this: =if(isblank(Sheet1!C3),"",Sheet1!C3) That way, you won't get a 0 in the cell in which the formula resides when Sheet1!C3 is blank. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Gord Dibben" <gorddibbATshawDOTca wrote in message . .. Tom In D4 of sheet2 enter =Sheet1!C3 Another way is to enter an = sign in D4 then switch to sheet1 and select C3 and hit ENTER key. And one more...........select C3 and switch to sheet2, select D4 and EditPaste SpecialPaste LinkOKEsc. In all cases, D4 will get the above formula. Gord Dibben MS Excel MVP On Fri, 16 Mar 2007 16:08:10 -0700, Tom wrote: I'm looking for a formula (I think a formula, or some other way) whereby I enter data in one cell on one worksheet and it simultaneously (or after a keystroke or two) fills in the same data in a cell that I select on another worksheet, all within the same workbook. E.g., I type in the name "Roger" in cell C3 on sheet 1. I would have previously set up a condition in a formula or some other way whereby anything I type in cell C3 of sheet 1 is repeated in cell D4 of sheet 2. In other words, Excel does the "copying" on-the-fly using my pre-determined cells, i.e., anything I type in C3 is automatically filled in D4 of another sheet I specify. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type data in one cell - and it automatically populates another cel
Couldn't make it this year.
Perhaps another time? Gord On Sat, 17 Mar 2007 21:49:39 -0400, "Anne Troy" wrote: :) Were you in Seattle? If yes, I'm so sorry I missed you. I had a unique opportunity to crash and met so many others. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Thanks Anne. I too often forget about warning posters of the zero issue and giving them a fix as you have done. Only drawback is a straight "paste links" won't add the error trap so you have to build the first formula from scratch then copy. Gord On Fri, 16 Mar 2007 23:19:46 -0400, "Anne Troy" wrote: To add to what Gord said, I often do something like this: =if(isblank(Sheet1!C3),"",Sheet1!C3) That way, you won't get a 0 in the cell in which the formula resides when Sheet1!C3 is blank. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Tom In D4 of sheet2 enter =Sheet1!C3 Another way is to enter an = sign in D4 then switch to sheet1 and select C3 and hit ENTER key. And one more...........select C3 and switch to sheet2, select D4 and EditPaste SpecialPaste LinkOKEsc. In all cases, D4 will get the above formula. Gord Dibben MS Excel MVP On Fri, 16 Mar 2007 16:08:10 -0700, Tom wrote: I'm looking for a formula (I think a formula, or some other way) whereby I enter data in one cell on one worksheet and it simultaneously (or after a keystroke or two) fills in the same data in a cell that I select on another worksheet, all within the same workbook. E.g., I type in the name "Roger" in cell C3 on sheet 1. I would have previously set up a condition in a formula or some other way whereby anything I type in cell C3 of sheet 1 is repeated in cell D4 of sheet 2. In other words, Excel does the "copying" on-the-fly using my pre-determined cells, i.e., anything I type in C3 is automatically filled in D4 of another sheet I specify. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type set amount of digits in one cell then automatically move to n | Excel Worksheet Functions | |||
Type 3 digits in one cell then automatically move to next cell. | Excel Discussion (Misc queries) | |||
Type info in one cell that automatically repeats in other cells. | Excel Worksheet Functions | |||
Excel - I type 9-6 in cell and it automatically changes to 9 June | New Users to Excel | |||
Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions |