Pasting in selected cells

  • Thread starter Thread starter saz2369
  • Start date Start date
S

saz2369

how can i copy cells from one worksheet and paste into selected cells that
has blank cells between them
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need macro to move to first blank cell in column 6
Activating hyperlinks 3
select all non-blank cells 3
pasting content copied from nonadajacent cells 1
Excel Data pastes into 2 cells not 1 1
UGhhhhh! Why is this so difficult - NO COPY "" 1
copying cell contents from one worksheet to another (re-sorted lis 2
MACRO PASTE CELL to COLUMN, SKIP ROWS 1

Back
Top