+ Reply to Thread
Results 1 to 5 of 5

Copy Next Number and Paste in Specific Cell

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    13

    Copy Next Number and Paste in Specific Cell

    Good day.

    I'm looking for a macro that could help me copy the next number in a column (the amount of numbers can vary every time) and paste the number in a specific cell.

    I have attached a sample sheet.

    What I would like to achieve is: the number displayed in Cell A5 be copied and pasted in Cell K1, once I press a macro button, it goes down to the next number (A6) and copy that and paste it into K1 again. This function continue until there is no number left in Column A to copy and paste. As the number list varies, one month there could be 2 numbers (A5 and A6) and other months there could be more than 1000 numbers.

    If someone can help me with this, I would appreciate it alot.
    Attached Files Attached Files
    Last edited by Elmarie_Potgieter; 06-12-2013 at 08:43 AM.

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

    Re: Copy Next Number and Paste in Specific Cell

    paste it into K1 again
    Twice on the same cell, or you meant L1?

  3. #3
    Registered User
    Join Date
    04-18-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Copy Next Number and Paste in Specific Cell

    Ab33, it should always paste in K1.

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Copy Next Number and Paste in Specific Cell

    Hi Elmarie_Potgieter
    maybe so
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-18-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Copy Next Number and Paste in Specific Cell

    Nilem thanx it works perfectly. You made my day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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