+ Reply to Thread
Results 1 to 3 of 3

Copying Rows and Adding to an Integer

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Seattle, WA
    MS-Off Ver
    Excel 365
    Posts
    8

    Copying Rows and Adding to an Integer

    Hello -

    I have a simple workbook that lists my current orders. I want to put in a macro that allows the user to make additional copies of a record/row (as many as they need) and add .1 to the PO number, as shown on the attached spreadsheet in rows 45 (original order number) through 47.

    I looked through the forums and I found how to copy the row using user input (MultipleRelease macro, included in the workbook) but not how to add the .1 to each additional copy.

    Any help would be appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Copying Rows and Adding to an Integer

    Here is your modified code.


    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-27-2011
    Location
    Seattle, WA
    MS-Off Ver
    Excel 365
    Posts
    8

    Re: Copying Rows and Adding to an Integer

    Thank you so much, mehmetcik! I have to look that over to see how it works! I appreciate your help a great deal.

+ 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] Locking cells in columns but allow copying and adding rows
    By Skully in forum Excel General
    Replies: 16
    Last Post: 02-25-2020, 10:49 AM
  2. Copying colums of formula and adding blank rows
    By tallgingerbloke in forum Excel General
    Replies: 8
    Last Post: 07-02-2011, 01:59 PM
  3. adding an integer to a string in code
    By pspyve in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2006, 07:45 PM
  4. adding and copying rows
    By CatherineN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2006, 05:07 PM
  5. [SOLVED] Copying and skipping (adding) rows
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2006, 02:40 PM

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