Import Data: on insert, shift data down and not right

[Guest]

Hi,

I'm importing data from an external source (notes database). The data is
being put in between different rows which have existing data. The problem I'm
stuck with is that on the insert of the data, I would like an existing data
to moved downwards but instead it's being moved to the right. I.e. the colums
are shifting right whereas I would like the rows to be moved down.

Can anyone please help with this.

Thanks

Lena

 

[Jim Rech]

It's not clear how you're doing this "insert" of data. Importing data
typically brings it in as a block, either in a new workbook or in a specific
location in an existing one, depending on how you do it. I'm not familiar
with an "import and insert" operation but that seems to be what you're
describing.

--
Jim Rech
Excel MVP
| Hi,
|
| I'm importing data from an external source (notes database). The data is
| being put in between different rows which have existing data. The problem
I'm
| stuck with is that on the insert of the data, I would like an existing
data
| to moved downwards but instead it's being moved to the right. I.e. the
colums
| are shifting right whereas I would like the rows to be moved down.
|
| Can anyone please help with this.
|
| Thanks
|
| Lena