How do I copy a range of data to another sheet?

[MrNobody]

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?

 

[Shane Devenshire]

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.

 

[MrNobody]

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...