-
Apr 3rd, 2012, 05:29 AM
#1
Thread Starter
New Member
Copy Cells To empty Positions On Different Sheet
Hi Was wondering if sombody could help
I have a excel problem
i need to copy a complete row of data into a new sheet but the code needs to move to the next blank row
I was thinking of using the Selection.End(xlDown).Select command but i have to admin my VB isnt up to scratch to use it
If i had the row of data in Sheet 1 row 2 and i need the whole row pasted in the next available row in sheet 2
is there a simple code to do it
thanks
steve
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|