Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Raminhos
 
Posts: n/a
Default Import Data: on insert, shift data down and not right

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
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"