how can I cut and paste a line in page1 to page 2 by clicking a button?

esco · #1 12-04-2013, 01:55 PM

yes it is right.
I mean after cut and paste worksheet 1 A2 and A3 to worksheet 2 A2 and A3, it should cut and paste my new data A2 and A3 in worksheet 1 to worksheet 2 next line B2 AND B3. this goes like this C3 C4 D3 D4 in worksheet 2...
I want excel cut and paste my new datas to other worksheets line by order

BobBridges · #2 12-05-2013, 07:34 AM

Ok, I think we're almost there. Let's try this new description:

Quote:

When I hit the Save button, I want it to do the following:

Get the name of the target worksheet from A4
Cut the data from A2 and A3.
Go to the target worksheet.
Find out which column is the next one available, and paste the data there. For example, if there's data already in column A through column E, then paste the data into F2 and F3.

How's that?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can you prevent an empty line from appearing in the first line of a page?	New Daddy	Word	10	11-18-2013 07:01 AM
Find, copy and paste into a new page	jperez84	Word VBA	24	09-20-2012 11:34 AM
How to paste into another app without line numbers?	Moonf4	Word	1	04-18-2011 03:16 PM
First line on page is truncated (top of line)	OwlCat1212	Word	0	02-14-2011 03:24 PM
How to cut and paste a graphic to a different page in word.?	soooty	Drawing and Graphics	1	08-12-2010 11:17 AM