Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying input to another cell
How can I enter text in one cell and have it copy to another cell
automatically, not using copy/paste feature. Such as type in date in cell A3 and it automatically appears in cell E33. Also, can this same feature work if I use a data validation list and want that same pull down feature selection to appear in another cell as well. Excel 2003. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying input to another cell
Seems you could put this formula in E33: =A3
When you change A3 the E33 will change. Do the same with your data valaditation cell where in the destination cell you enter ='whatever the dv cell is' Or you could use this event macro to do the same, adjust the ranges to suit your sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Target < Range("A3") Then Exit Sub Range("E33").Value = Range("A3").Value End Sub Right click the tab and click View Code and paste into the large white area. HTH Regards, Howard "ghighigirl" wrote in message ... How can I enter text in one cell and have it copy to another cell automatically, not using copy/paste feature. Such as type in date in cell A3 and it automatically appears in cell E33. Also, can this same feature work if I use a data validation list and want that same pull down feature selection to appear in another cell as well. Excel 2003. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying input to another cell
Unless you're hiding some special circumstances, you should be able type the
formula =A3 down in cell E33 and accomplish what you want. Same for the other situation with the validated list. "ghighigirl" wrote: How can I enter text in one cell and have it copy to another cell automatically, not using copy/paste feature. Such as type in date in cell A3 and it automatically appears in cell E33. Also, can this same feature work if I use a data validation list and want that same pull down feature selection to appear in another cell as well. Excel 2003. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying input to another cell
This did the trick. I didn't have to enter the macro . I used the same
formula on all cells. Thanks so much. "ghighigirl" wrote: How can I enter text in one cell and have it copy to another cell automatically, not using copy/paste feature. Such as type in date in cell A3 and it automatically appears in cell E33. Also, can this same feature work if I use a data validation list and want that same pull down feature selection to appear in another cell as well. Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking input in a cell and return by copying info from a other c | Excel Worksheet Functions | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
Copying cell with input range to different worksheet | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel |