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

		Microsoft Office Forums > Microsoft Excel > Excel
how can I cut and paste a line in page1 to page 2 by clicking a button?

12-05-2013, 07:34 AM

BobBridges BobBridges is offline

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

Office 2010 32bit

Expert

Join Date: May 2013

Location: USA

Posts: 700

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:37 AM.