+ Reply to Thread
Results 1 to 3 of 3

Paste Row from Worksheet to another above and not into first empty row

  1. #1
    Registered User
    Join Date
    01-09-2018
    Location
    West Midlands, England
    MS-Off Ver
    2016
    Posts
    75

    Paste Row from Worksheet to another above and not into first empty row

    So I have a vba code that looks on 1 workbook for a row marked with "x" and where it is it opens another workbook and pastes the row into the first empty row from the bottom up.

    What I need it to do now is paste this to the top of the row (e.g. above the first line of data not including the headers), or if easier it will always be above row 6.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    10-16-2023
    Location
    Poland
    MS-Off Ver
    Excel 2019 32bit WIN10
    Posts
    88

    Re: Paste Row from Worksheet to another above and not into first empty row

    Instead:
    Please Login or Register  to view this content.
    Insert:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-09-2018
    Location
    West Midlands, England
    MS-Off Ver
    2016
    Posts
    75

    Re: Paste Row from Worksheet to another above and not into first empty row

    Quote Originally Posted by Tajan View Post
    Instead:
    Please Login or Register  to view this content.
    Insert:
    Please Login or Register  to view this content.
    Thanks very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Command Button that will Copy& Paste into next empty column to the right in SAME worksheet
    By Kenyanbanker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2018, 03:49 PM
  2. copy & paste range from worksheet to first empty row in a list in another workbook
    By birdgirl in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2015, 01:35 PM
  3. Replies: 1
    Last Post: 12-18-2014, 04:15 PM
  4. VBA to copy non empty cells then paste to next available cell in another worksheet
    By Chrisbrough88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2014, 08:07 AM
  5. Copy rows until empty row reached and paste in new worksheet
    By ebbo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-20-2013, 01:51 AM
  6. Copy Range from Worksheet 2, Paste to Next Empty Row Worksheet 1
    By oOarthurOo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2010, 04:07 PM
  7. Cut & Paste (Move) Filtered Data to 1st empty row in another worksheet
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2009, 10:18 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1