+ Reply to Thread
Results 1 to 3 of 3

Copy Paste and Loop till last column with data

  1. #1
    Registered User
    Join Date
    11-07-2011
    Location
    oxford, england
    MS-Off Ver
    Excel 2003
    Posts
    1

    Copy Paste and Loop till last column with data

    Hi there. Please help.
    I have data spanning across over 10,000 rows and need to copy and paste months (Jan-Dec in column A of this data. I therefore need a macro that will loop through the spreadsheet until there's no more data in column B.

    It looks like this:

    Month Cost Centre
    Jan 30002000
    Feb 30002000
    Mar 30002000
    Apr 30002000
    May 30002000
    Jun 30002000
    Jul 30002000
    Aug 30002000
    Sep 30002000
    Oct 30002000
    Nov 30002000
    Dec 30002000
    30002001
    30002001
    30002001
    30002001
    30002001
    30002001
    30002001
    30002001
    30002001
    30002001
    30002001
    30002001
    30002002
    30002002
    Please help. Many thanks.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Copy Paste and Loop till last column with data

    hi, eirumba, please check attachment, run code "FillMonths"
    Attached Files Attached Files

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Copy Paste and Loop till last column with data

    Please Login or Register  to view this content.



+ 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