| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to I copy text from a range of cells to another single cell?
Hi
I have set-up my excel work sheet to allow codes (text) to be entered into a range of cells for the pupose of grading. EG. Cells A20:A25 allow for a a single number to be entered into ONE only of these cells, then B20:B25 would have a scoring guide and C20:C25 would have another marking code in text to be entered into the same row as the number was entered in A20:A25. This is where I am stumped. I am unable to copy the entered code (text) from C20:C25 Please be aware that if the entered number in A20:A25 is 3 (hypothetically) this does not mean that the code (text) in C20:C25 will always be G (or any other code each and every time). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| How do you write 2 lines of text in 1 cell rather than use 2 cells | Excel Discussion (Misc queries) | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
| looking for range of text in a single cell | Excel Discussion (Misc queries) | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Threaded Mode
