Copy range of cells

G

guest1029

Hi Excel Gurus,

I want to copy a dynamic range of cells below another dynamic range o
cells. Any clue as how to do this as I am doing this for the firs
time
 
J

Jim Rech

Is this a VB question? Can you provide an example of a typical situation?

--
Jim Rech
Excel MVP
| Hi Excel Gurus,
|
| I want to copy a dynamic range of cells below another dynamic range of
| cells. Any clue as how to do this as I am doing this for the first
| time.
|
|
| ---
|
|
 
G

guest1029

Hi,

I ran a SAP Query and the result comes in the form of two tables In
single sheet excel. I want to copy the first table below the secon
table. The issue is that the length of the table varies as the lengt
represents the number of transactions per day which obviously vary. Th
two tables are in the same sheet and the no of rows of both the tabl
varies.

Hope u got my questions.

I have to copy a dynamic range below another dynamic range.

thanks
 
J

Jim Rech

I still have very little to work with. This is an example of a useful
example:

"I have a sheet with two tables. They vary in the number of rows but the
first one starts at A1 and has a variable number the columns. There are no
breaks in the data to the end of data down column A or across row 1. The
second table starts 2 rows below table 1. It also has no breaks in data
down column A or across its starting row.

I want to copy the first table 2 rows below the second, thus leaving me with
three tables."


--
Jim Rech
Excel MVP
| Hi,
|
| I ran a SAP Query and the result comes in the form of two tables In a
| single sheet excel. I want to copy the first table below the second
| table. The issue is that the length of the table varies as the length
| represents the number of transactions per day which obviously vary. The
| two tables are in the same sheet and the no of rows of both the table
| varies.
|
| Hope u got my questions.
|
| I have to copy a dynamic range below another dynamic range.
|
| thanks.
|
|
| ---
|
|
 
Top