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
"Raminhos" wrote in message
...
| 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