| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to copy a text value from one worksheet to another
Thank you Gord, that worked!!!!!
"Gord Dibben" wrote: Toria It is also possible that the cell that shows the formula was pre-formatted as Text. Format to General then F2 and ENTER. Gord Dibben MS Excel MVP On Fri, 10 Nov 2006 14:15:02 -0800, Toria wrote: Thanks for responding. I tried that and then my cell B4 doesn't display what is in the cell of A1 it displays the formula. How can I get it to hide the formula and just show the value of field A1? Thanks a bunch! "tim m" wrote: In B4 in sheet 2 put =Sheet1!A1 That will put the contents of A1 in sheet 1 into that cell, when A1 changes the result will change in B4 sheet 2. Is that what you wanted? "Toria" wrote: I am creating a report for my boss. In one worksheet I have fields where she can enter text or numbers. Then in another worksheet I have some formulas that work off the previous worksheet. I need a function that will copy the text in a column on the first worksheet and place it in a specified cell on the other worksheet. I hope this makes sense. Example: Cell A1 in Worksheet 1 = Financial Manager Now I want to copy Financial Manager into Cell B4 in Worksheet 2 The trick is the text in cell A1 in Worksheet 1 will always change depending on what my boss puts in it. But I want it to always copy to a specified cell in the other worksheet. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charity Auction Worksheet. - Copy a row of data - THANKS | Excel Worksheet Functions | |||
| Worksheet 1 exact copy of worksheet 2, but in different order | Excel Discussion (Misc queries) | |||
| how Excel can copy the data in a row of worksheet to other? | Excel Worksheet Functions | |||
| Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
Hybrid Mode
