Results 1 to 5 of 5

Copy Next Number and Paste in Specific Cell

Threaded View

  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.

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