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

BobBridges · #4 12-03-2013, 09:53 PM

Ok, I think I understand. Tell me whether this is right:

Quote:

I have a worksheet name in A1, and some data in A2 and A3. In A4 is a button. I'd like the button to cause Excel to cut the data from A2 and A3, and paste it to cells in the worksheet named in A1.

Is that right so far? That doesn't sound too hard. But then you said that after the paste, "the line must go to next line I mean in order". What does that mean? By "the line", do you mean what's displayed to the user, or the data that's already been moved to another worksheet?

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