+ Reply to Thread
Results 1 to 2 of 2

Duplicate a work area N times , and increasing number in a cell

  1. #1
    Registered User
    Join Date
    12-09-2019
    Location
    italy
    MS-Off Ver
    ms office home and business 2013
    Posts
    1

    Duplicate a work area N times , and increasing number in a cell

    hi,
    i have a working area, label type.

    for each of my specifical situation, i need to complete this label and duplicate it n times .
    But for each duplicate , in a specific cell i need that the number in this cell increase +1.

    for example : i hade to duplicate the work area 35 times, in the last cell at the bottom on the left you can find X and 35.

    So after had duplicate all the area i need to have
    1 35
    2 35
    3 35
    ....
    35 35

    is it possible?
    I need a number of duplicates as i set the N ( in this example N=35)
    attached you can find the file i need to duplicate
    thansk in advance
    regards
    federico
    Last edited by grinta5; 12-09-2019 at 12:24 PM.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,815

    Re: Duplicate a work area N times , and increasing number in a cell

    Ciao Federico and welcome to the Forum. I don't see any file attached. To attach a file, click on the "Go Advanced" button. Scroll down a bit and click "Manage Attachments".
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ 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. How to duplicate rows by x number of times
    By carlos.guerrero18 in forum Excel General
    Replies: 2
    Last Post: 07-09-2019, 04:14 PM
  2. Replies: 2
    Last Post: 11-02-2015, 07:57 PM
  3. [SOLVED] Duplicate a sheet a number of times
    By AB33 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2012, 11:42 AM
  4. Count number of times value is present i area.
    By bendixboogie in forum Excel General
    Replies: 3
    Last Post: 07-06-2011, 01:10 AM
  5. Excel 2007 : Duplicate rows a given number of times
    By kayell in forum Excel General
    Replies: 1
    Last Post: 04-03-2011, 12:58 PM
  6. Replies: 10
    Last Post: 11-08-2010, 02:36 PM
  7. Duplicate number increasing extention
    By cruizer in forum Excel General
    Replies: 7
    Last Post: 10-10-2010, 05:04 AM

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