ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab Keystroke in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/138896-tab-keystroke-excel.html)

Snakeoids

Tab Keystroke in Excel
 
Greetings,
I have data in Excel that I want to copy and paste into another application.
Each row in Excel has approx 13 cells of data to be pasted into 13 fields in
the other program.
The problem is that when I paste the data into the other application, the
cursor tries to paste all of the data into the field that it's currently in;
the cursor does not paste into the respecive fields in this other program.
When I manually press the TAB key the cursor will move, so I figured that if
I ingrain a TAB keystroke into my Excel data that it would work, but no luck.
Any ideas on this one. It's a lot of data to enter manually and the clock
is ticking for me. Thanks in advance.

Snakeoids.

BoniM

Tab Keystroke in Excel
 
What is the other program? Try selecting the entire row there before
pasting. For example, if it were Access, it would work if you clicked the
row select button to the left of the first field and then pasted, but not if
you just clicked in the first field. It would even work to paste multiple
rows. :-)

"Snakeoids" wrote:

Greetings,
I have data in Excel that I want to copy and paste into another application.
Each row in Excel has approx 13 cells of data to be pasted into 13 fields in
the other program.
The problem is that when I paste the data into the other application, the
cursor tries to paste all of the data into the field that it's currently in;
the cursor does not paste into the respecive fields in this other program.
When I manually press the TAB key the cursor will move, so I figured that if
I ingrain a TAB keystroke into my Excel data that it would work, but no luck.
Any ideas on this one. It's a lot of data to enter manually and the clock
is ticking for me. Thanks in advance.

Snakeoids.


Snakeoids

Tab Keystroke in Excel
 
The other program is by Telus (the phone company). It's called Interaction
Manager for they Call Centre Anywhere program. I've tried the row pasting
thing, but no dice.

Snakeoids.

"BoniM" wrote:

What is the other program? Try selecting the entire row there before
pasting. For example, if it were Access, it would work if you clicked the
row select button to the left of the first field and then pasted, but not if
you just clicked in the first field. It would even work to paste multiple
rows. :-)

"Snakeoids" wrote:

Greetings,
I have data in Excel that I want to copy and paste into another application.
Each row in Excel has approx 13 cells of data to be pasted into 13 fields in
the other program.
The problem is that when I paste the data into the other application, the
cursor tries to paste all of the data into the field that it's currently in;
the cursor does not paste into the respecive fields in this other program.
When I manually press the TAB key the cursor will move, so I figured that if
I ingrain a TAB keystroke into my Excel data that it would work, but no luck.
Any ideas on this one. It's a lot of data to enter manually and the clock
is ticking for me. Thanks in advance.

Snakeoids.



All times are GMT +1. The time now is 07:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com