Results 1 to 11 of 11

copy till last used row of a column and paste it into another column of another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-01-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    26

    copy till last used row of a column and paste it into another column of another sheet

    Every week I get data with random number of rows and I need to rearrange those data in certain order so it can accommodate with our system.

    I have attached spreadsheet and would appreciate your assistance with macro to address following issue

    1. need to find last used row and copy column I on sheet("internal") and paste to A2 in sheet("Int-SendOut")
    2. need to find last used row and copy column H on sheet ("Internal") and paste to B2 in sheet("Int-SendOut")
    3. need to find last used row and copy column C on sheet("Internal") and paste to C2 in sheet(Int-Sendout")

    I am wondering what would be vba code to achieve the result based on last used row.

    Thank you very much in advance for your assistance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-30-2015, 04:38 PM
  2. [SOLVED] Macro to copy and paste only unique values from one column to another column in same sheet
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2014, 05:44 AM
  3. copy column and it's row value till column blank found
    By nareshkt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2013, 03:20 AM
  4. Copy entire selected column to next columns till last column
    By siroos12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2013, 05:20 AM
  5. Copy Paste and Loop till last column with data
    By eirumba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2011, 07:23 AM
  6. Copy and Paste Multiple Cells in the same row till last Last Column
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2010, 03:40 PM
  7. Copy and Paste till last Last Column
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2010, 05:43 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