+ Reply to Thread
Results 1 to 7 of 7

Macro To Fill A Series

  1. #1
    Registered User
    Join Date
    12-11-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    4

    Macro To Fill A Series

    A B
    1 Reference Number Project Type
    2 2013MW001 Wireless
    3 2013MW002 Installation
    4
    5
    6

    I have an excel sheet with the above columns. I want to write a macro such that when I run it, it searches the next available cell (which would be A4) and auto populates it with the series (2013MW003) and so on.

  2. #2
    Forum Contributor
    Join Date
    06-18-2012
    Location
    Chennai, India
    MS-Off Ver
    Excel 2003, 2010
    Posts
    212

    Re: Macro To Fill A Series

    Post a sample file so that it will be easy to give the exact solution you were looking for....

  3. #3
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Macro To Fill A Series

    Maybe:
    Please Login or Register  to view this content.
    Last edited by millz; 12-11-2013 at 05:57 AM. Reason: 5->6

  4. #4
    Registered User
    Join Date
    12-11-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Macro To Fill A Series

    Series Continuation.png

    That's how it looks. and I need the next empty cell in column A to be filled with the series continuation.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro To Fill A Series

    Does this help?

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    12-11-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Macro To Fill A Series

    @John, perfect it helped. Thanks a ton!

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro To Fill A Series

    You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

    9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

+ 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. Fill Series when filter is on with a Macro
    By bigbavarian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2009, 09:16 PM
  2. Macro to replace Fill Series
    By ferretydeath in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2008, 10:59 AM
  3. Macro - Fill Series Requires Two Rows of Data!?
    By Paddy9 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-19-2007, 03:43 PM
  4. Replies: 1
    Last Post: 01-29-2006, 08:55 AM
  5. [SOLVED] Filling in a Date Series using the Fill | Series menu command
    By Bob C in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2005, 08:06 PM

Tags for this Thread

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