| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting in selected cells
how can i copy cells from one worksheet and paste into selected cells that
has blank cells between them |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasting in selected cells
You can't paste a group of cells into individual other cells. Your options
are to either 1) Sort the list you are copying into, assuming your copy to cells have something in common 2) Use a formula... =Sheet1!A2 or so. "saz2369" wrote: how can i copy cells from one worksheet and paste into selected cells that has blank cells between them |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasting in selected cells
Use
=Sheet1!A1 in sheet2 any cell accordingly you can copy like this anywhere in the same workbook. When you do so and edit the data of the parent cell from where you have copied the data & pasted. The changes will reflect in the cells where the data is pasted. -- _______________________ Click "Yes" button if it helps ________ Thanks Suleman Peerzade "saz2369" wrote: how can i copy cells from one worksheet and paste into selected cells that has blank cells between them |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting with multiple sheets selected loses undo history- why? | Excel Discussion (Misc queries) | |||
| How do I prevent copy and pasting into a selected range of a works | Excel Discussion (Misc queries) | |||
| Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
| Cells are selected but aren't displayed as selected | Excel Worksheet Functions | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Linear Mode
