+ Reply to Thread
Results 1 to 8 of 8

copy paste entire row into a specific cell in sheet 2

  1. #1
    Forum Contributor
    Join Date
    06-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    199

    copy paste entire row into a specific cell in sheet 2

    hello

    i found this macro in this site and it kind of works for me..

    i just need somebody to edit it such that when the macro is run the data will be pasted starting in I5 of sheet 2. right now it starts pasting at a5. i tried changing the code myself but no lock

    i hope somebody can help me.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: copy paste entire row into a specific cell in sheet 2

    It looks like my code

    Please Login or Register  to view this content.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: copy paste entire row into a specific cell in sheet 2

    Hi, melody10,

    your thread title does not comply with what you are asking as it is impossible to paste a row into any other starting cell than in Column A. You should alter the title to match what you are asking (thatīs a range, not a row).

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: copy paste entire row into a specific cell in sheet 2

    Hi Holger,
    I am not sure if I am breaking forum's rule by posting to this thread since the non-compliance of the rules is not clear from your post.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    06-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    199

    Re: copy paste entire row into a specific cell in sheet 2

    holger... my apologies if i have broken any forum's rule. will not do it again...

    ab33... as always you have been a very great help to me. the attachment you gave works perfectly. i cannot express my gratitude. thanks again

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: copy paste entire row into a specific cell in sheet 2

    melody10,
    No, you have not broken any rule.
    You are welcome!

  7. #7
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: copy paste entire row into a specific cell in sheet 2

    Hi, AB33,

    No, you have not broken any rule.
    What about Forum Rule #1:
    Use concise, accurate thread titles.
    Might be a good start to think about your post.

    Ciao,
    Holger

  8. #8
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: copy paste entire row into a specific cell in sheet 2

    Which post you are talking about? I did not post any thread. I replied to a thread.
    Your reply was too vague. If the OP has broken the rule, you should have blocked the thread so that others will be deterred from posting ,as the rule stipulates.
    That is why I asked you polity to clarify your reply, but as always your reply is sarcastic.

+ 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. [SOLVED] Copy & Paste Special entire row from one sheet to another if cell is contains "NOTOK"
    By rvkadu1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2013, 04:58 AM
  2. Search for specific date range, copy entire row and paste to new worksheet
    By turias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2013, 03:57 PM
  3. to copy paste the entire row to the new sheet
    By karanpreet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-15-2013, 10:51 AM
  4. Find specific cell, copy row from several tabs and paste in summary sheet
    By helnil in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-11-2012, 08:16 AM
  5. [SOLVED] Macro Help: IF specific wording is found in a cell, THEN copy entire row to new sheet
    By csch123 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-13-2012, 03:16 PM

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