I need to copy a range of cells data from one worksheet to another.

In the source worksheet, I have a specific number of columns but the numbers
of rows should be dynamic, it should be able to expand until it finds an
empty row.

It then takes this range of cell data and copies it to another worksheet
starting at a specific cell (namely, A9)

How do I do this?

Hi,

suppose the data starts in A1 and goes to column C. Select A1:C1 and then
press Shift+Ctrl+Down Arrow. Press Ctrl C to copy it, move to the other
sheet and press Ctrl V to paste it.

You may also be able to use the shortcut key Ctrl+A to select all the data
provided there is not data adjacent to the last column or the data you want
to copy. Then proceed with Ctrl+C ---> Ctrl+V as above.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"MrNobody" wrote:

> I need to copy a range of cells data from one worksheet to another.
>
> In the source worksheet, I have a specific number of columns but the numbers
> of rows should be dynamic, it should be able to expand until it finds an
> empty row.
>
> It then takes this range of cell data and copies it to another worksheet
> starting at a specific cell (namely, A9)
>
> How do I do this?

Oh... I meant to be able to do it using a function, not manually.

Is there no way?

Only a macro script can do something like that?

For example, I have worksheet "A" and worksheet "B"

I want to select all the data from "B"'s A1 -> Ax where x is the number of
rows of data it has. Then it copies this list of data into "A"'s B2 cell, but
with multiple values they proceed to B3, B4, etc...

"Shane Devenshire" wrote:

> Hi,
>
> suppose the data starts in A1 and goes to column C. Select A1:C1 and then
> press Shift+Ctrl+Down Arrow. Press Ctrl C to copy it, move to the other
> sheet and press Ctrl V to paste it.
>
> You may also be able to use the shortcut key Ctrl+A to select all the data
> provided there is not data adjacent to the last column or the data you want
> to copy. Then proceed with Ctrl+C ---> Ctrl+V as above.
>
> --
> If this helps, please click the Yes button
>
> Cheers,
> Shane Devenshire
>
>
> "MrNobody" wrote:
>
> > I need to copy a range of cells data from one worksheet to another.
> >
> > In the source worksheet, I have a specific number of columns but the numbers
> > of rows should be dynamic, it should be able to expand until it finds an
> > empty row.
> >
> > It then takes this range of cell data and copies it to another worksheet
> > starting at a specific cell (namely, A9)
> >
> > How do I do this?