| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Paste in a right cell
How do I set that I ONLY can paste a col A info from sheet1 into sheet2 at
cells C3 and S3? I'd like to have an error (pop up) if I paste in wrong cell. ONLY allow to paste in cell C3 and S3. Thanks |
|
#2
|
|||
|
|||
|
What version of Excel?
In 2002 and 2003 you could lock all cells except C3 and S3. Then Protect the sheet with "Select locked cells" unchecked so only the unlocked C3 and S3 can be selected. Gord Dibben Excel MVP On Wed, 28 Sep 2005 10:01:35 -0700, bioyyy wrote: How do I set that I ONLY can paste a col A info from sheet1 into sheet2 at cells C3 and S3? I'd like to have an error (pop up) if I paste in wrong cell. ONLY allow to paste in cell C3 and S3. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste from Word table so that 1 table cell = 1 Excel cell | Excel Discussion (Misc queries) | |||
| Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
| excel - numbers as text | New Users to Excel | |||
| sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
