Selected the rows transfer other file or other page.

Hi,
How can i transfer to other file or other page that I 've been selected the rows .
Please ,Can you help me.

Copy-Paste

Hi arthurbr,
Thank you for replay.But what i 'll do for thousend rows.
Please look up again my question.

Boy, that's a difficult one. I could show you how to do that with a macro (VBA procedure). And, even using a macro it is not as easy as it would seem because you would have to iterate through the areas of the range of cells selected.

If you have 1000 rows, I suspect that you are not selecting them one at a time (at least I hope not); but, rather using some sort of custom autofilter.

Anyway, if you feel up to a VBA procedure, let me know. To be most helpful, I would want to know if you want to move the cells one at a time (if you are selecting them individuall) or all at once. Also, if you are using autofilter or not. If you want some indication of what has already moved (perhaps higlighting those cells). If you are really interested in moving the entire row, or only the one cell selected.

Chippy, if one were going to use that approach, it seems it would be simpler to copy everything over and delete the ones you don't want.

But, it does make me think ... could one somehow use a named range? Select the cells you want from page 1, name them, and somehow use a formula to write them to page 2?

So far, this does not seem to be working for me. Excel's built-in intersect operator appears to detest the insect operator when the Named range is not contiguous.

OK, here it is. I am not particularly happy with this, so hopefully someone can build on it.

First, I selected the cells on page 1 and gave this Range the Name "select".

On page 2, column A contains the formula:

Please Login or Register  to view this content.

This formula is filled down as many rows as necessary.

On page 2, cell C1 contains the number 1. Starting in cell C2, this formula is filled down:

Please Login or Register  to view this content.

Hi,
Thank you very much for your reply.