Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Automate copy / paste

Good day ,
I am asking for help with the following matter please.

I need to copy a single row on an XL database worksheet, and paste to another
workbook/worksheet.
In the 2nd workbook/worksheet ,I would like the 1st pasting to be entered in
a certain row , and each following pasting to be 1 row higher than the
previous paste.

Can this be done automatically?

I am almost new to FORUMS and my XL database experience is not exactly great.

THX
Paul

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200912/1

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Automate copy / paste

PAULGOR wrote:
Good day ,
I am asking for help with the following matter please.

I need to copy a single row on an XL database worksheet, and paste to another
workbook/worksheet.
In the 2nd workbook/worksheet ,I would like the 1st pasting to be entered in
a certain row , and each following pasting to be 1 row higher than the
previous paste.

Can this be done automatically?

I am almost new to FORUMS and my XL database experience is not exactly great.

THX
Paul


.HI Paul again, here is some more info to assist.

I need to copy from a workbook named A1.XLS , and cells to copy are in row D7:
L7 ,
This row will always be the row to be copied .ie remains a
static row.

I need to paste to a workbook named A2.XLS , and paste into row D1:L1
initially, an after
that into row D2:L2 , then D3:L3 , then D4:L4 then forever more where the
row number
increases by one

Hope this will help , and everyone "ENJOY YOUR FESTIVE
SEASON"

My Regards

Paul

--
Message posted via http://www.officekb.com

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
automate copy and paste Richard Excel Discussion (Misc queries) 1 September 24th 08 12:32 AM
Automate Cut & Paste jlo Setting up and Configuration of Excel 2 September 15th 08 02:11 PM
Any (clever) way to automate ROW:COL in copy/paste??? Zilla[_2_] Excel Worksheet Functions 7 March 26th 07 03:30 AM
Automate cut/paste functions - Help! Greg Excel Discussion (Misc queries) 2 June 13th 05 08:08 PM
HELP....Is there a way to automate copy/paste special/transpose - Mel Excel Worksheet Functions 7 March 29th 05 12:17 AM


All times are GMT +1. The time now is 12:08 PM.

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

About Us

"It's about Microsoft Excel"