+ Reply to Thread
Results 1 to 6 of 6

VBA to loop through each *AIPRSU* Sheet to create a sequence of numbers in column M

  1. #1
    Registered User
    Join Date
    06-04-2022
    Location
    Prague
    MS-Off Ver
    Office 365
    Posts
    7

    VBA to loop through each *AIPRSU* Sheet to create a sequence of numbers in column M

    Hello!

    I need help with a macro - my goal is to have in each sheet whose name starts with "AIPRSU" a sequential numbering in column M, starting from cell M2.

    Unfortunately the current macro that I have implemented does not do this separately for each AIPRSU sheet, so I need to get it fixed somehow.

    Thank you everyone who may engage in this request!

    Here below is the code that requires correction:

    Please Login or Register  to view this content.
    Capture.PNG
    Last edited by alansidman; 06-04-2022 at 09:45 PM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: VBA to loop through each *AIPRSU* Sheet to create a sequence of numbers in column M

    Hi, please read the forum rules on how to embed code and please attach a file instead of an image of the worksheet will make it easier to foresee you with a satisfactory answer
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,516

    Re: VBA to loop through each *AIPRSU* Sheet to create a sequence of numbers in column M

    How to use code tags.
    Attachment 782886

  4. #4
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,206

    Re: VBA to loop through each *AIPRSU* Sheet to create a sequence of numbers in column M

    Try it:
    Please Login or Register  to view this content.
    Artik

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,858

    Re: VBA to loop through each *AIPRSU* Sheet to create a sequence of numbers in column M

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  6. #6
    Forum Contributor Dante Amor's Avatar
    Join Date
    07-24-2020
    Location
    MEXICO
    MS-Off Ver
    Excel 2013
    Posts
    212

    Re: VBA to loop through each *AIPRSU* Sheet to create a sequence of numbers in column M

    Here is another macro for you to consider:

    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)

Similar Threads

  1. [SOLVED] Formula to create a sequence of numbers every month
    By peterderrington in forum Excel General
    Replies: 5
    Last Post: 01-21-2021, 12:37 PM
  2. [SOLVED] Code to create numbers in sequence
    By GKT in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-16-2014, 07:24 AM
  3. [SOLVED] Create 19rows Add numbers in sequence excel/access2007
    By accessobsess in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2013, 12:26 PM
  4. [SOLVED] Macro to create new sheets with numbers in sequence
    By canyflyer in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-21-2013, 07:11 PM
  5. Loop Through Column A On Sheet 1 To Create Tabs With Each Workers' Names
    By Richie77777 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-29-2013, 06:56 AM
  6. [SOLVED] Creating a sequence based on numbers in one column and adding "01,02..." to a new sequence
    By JCR1968 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 08:06 AM
  7. Replies: 6
    Last Post: 08-02-2006, 11:40 AM

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