+ Reply to Thread
Results 1 to 25 of 25

Need some help with duplicate numbering data merge

  1. 02-05-2016, 09:26 PM #1
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Cool Need some help with duplicate numbering data merge

    Hey all.
    Been a while...
    I am working with an InDesign document where I am numbering a 2-part NCR document (a receipt book).
    I have 10 pads with 50 sheets per.
    Here is an example where I have hand numbered the .csv data source linked to the ID file.
    PAD1 PAD2 PAD3
    23450 23454 23458
    23450 23454 23458
    23451 23455 23459
    23451 23455 23459
    23452 23456 23460
    23452 23456 23460
    23453 23457 23461
    23453 23457 23461

    The top header rows needs to extend on to "PAD10".
    The first column will extend on down to 25, with the top of the next column starting with 26... etc etc.
    Due to the fact that this project will eventually grow into hundreds of pads, I am looking for a straightforward method to calculate the values automatically.

    Attached is a sample sheet with the same values.
    I appreciate any assistance with this one y'all

    -slimp
    Attached Files Attached Files
    Last edited by kevindowney; 02-05-2016 at 11:48 PM.
    Reply With QuoteRegister To Reply
  2. 02-06-2016, 02:29 AM #2
    David A Coop
    David A Coop is offline
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Need some help with duplicate numbering data merge

    Sorry Kevin,

    I don't get what you're asking.

    I assume you want 10 columns from PAD1 ... PAD10. Easy enough. Just click on the PAD3 cell and drag right.

    Now I'm lost. You said :
    The first column will extend on down to 25
    . What does this mean - your example shows only 4 different numbers in each column - each one duplicated on the cell below.

    Can you please show a better example.

    Regards,

    David
    Reply With QuoteRegister To Reply
  3. 02-06-2016, 12:03 PM #3
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Talking Re: Need some help with duplicate numbering data merge

    I can see where you would be confused.
    See if this explains it a bit better.
    I have attached a better example.

    02doubles-rows-columns.xlsx

    I can manually enter the number where the sequence begins in cells "A2" & "A3".
    I would like the formula(s) to first calculate and fill the rest of column "A" as shown... 23451, 23451, 23452, 23452, 23453, 23453... etc.
    Then, I need the columns "B" through "J" to begin where the preceding column ends, plus 1.

    So if column "A" ends with "23459, 23459", column "B" begins with ""23460, 23460" and so on ending with cell "J21".

    Not sure here, but cell "L2" could be a multiplier of how many numbers I need in each column...

    Make sense?

    If you need more info I will try to explain better.
    Thanks

    -slimp
    Reply With QuoteRegister To Reply
  4. 02-06-2016, 02:35 PM #4
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Hi Kevin

    This Code in the attached will prompt you for a Start Number (23450 per your example...but what ever you choose). I've defaulted the Sheets per Pad to 50 (as you indicated). CTRL + x will fire the Code.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  5. 02-06-2016, 03:56 PM #5
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Need some help with duplicate numbering data merge

    Maybe this will help you.
    Enter in A2 and fill across to column J and down to row 9
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    1
    		 PAD1 PAD2 PAD3 PAD4 PAD5 PAD6 PAD7 PAD8 PAD9 PAD10
    2
    23450
    23454
    23458
    23462
    23466
    23470
    23474
    23478
    23482
    23486
    3
    23450
    23454
    23458
    23462
    23466
    23470
    23474
    23478
    23482
    23486
    4
    23451
    23455
    23459
    23463
    23467
    23471
    23475
    23479
    23483
    23487
    5
    23451
    23455
    23459
    23463
    23467
    23471
    23475
    23479
    23483
    23487
    6
    23452
    23456
    23460
    23464
    23468
    23472
    23476
    23480
    23484
    23488
    7
    23452
    23456
    23460
    23464
    23468
    23472
    23476
    23480
    23484
    23488
    8
    23453
    23457
    23461
    23465
    23469
    23473
    23477
    23481
    23485
    23489
    9
    23453
    23457
    23461
    23465
    23469
    23473
    23477
    23481
    23485
    23489
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  6. 02-06-2016, 04:52 PM #6
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Talking Re: Need some help with duplicate numbering data merge

    This is great! Thanks so much for your help.
    I have found that editing the values here...

    Please Login or Register  to view this content.
    I can customize it to whatever quantity my project calls for.

    From one Buckeye to another!
    Cheers.

    -slimp
    Reply With QuoteRegister To Reply
  7. 02-06-2016, 05:00 PM #7
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Hi Kevin

    A Tennessee Buckeye? Must be in a former life.

    If you wish this capability
    I can customize it to whatever quantity my project calls for
    uncomment these lines of Code.
    Please Login or Register  to view this content.
    Just make certain that ans1 is an even number (even this can be built in with error checking).
    Reply With QuoteRegister To Reply
  8. 02-06-2016, 05:01 PM #8
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Re: Need some help with duplicate numbering data merge

    Thanks newdoverman.
    Easy to manipulate this one as well.
    Just some simple math...
    Changing the value of "4" in your formula to however many sheets per pad (divided by 2) is ideal for each specific project.
    All I have to do then is add or remove headers to accommodate the number of pads I need to number.

    I will post the finished mockup of the design directly.
    This may help some InDesign users looking for a solution to this type exercise.
    Reply With QuoteRegister To Reply
  9. 02-06-2016, 05:14 PM #9
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Re: Need some help with duplicate numbering data merge

    I like!
    Perfect.
    I love running code on this... a great way to impress the boss and co-workers as well.
    HA.

    Question.
    Can we add something that will populate the header row with the number of pads (PAD1, PAD2 etc etc)?
    That would make it complete.

    I will post the finished mockup of the piece directly.
    This may help some InDesign users looking for a solution to this type exercise.

    Yeah, former life... moved here from Dayton area back in 2000.
    Hard to convince these Vols that the BIG10 is better than the SEC though.
    Reply With QuoteRegister To Reply
  10. 02-06-2016, 05:18 PM #10
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Need some help with duplicate numbering data merge

    If you want to use formulae and also want to specify the number of rows and starting number this should do it.
    Enter in A4 and fill across and down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    1
    		 Starting #
    23450
    2
    Rows
    8
    3
    		 PAD1 PAD2 PAD3 PAD4 PAD5 PAD6 PAD7 PAD8 PAD9 PAD10 PAD11 PAD12 PAD13 PAD14 PAD15 PAD16
    4
    23450
    23454
    23458
    23462
    23466
    23470
    23474
    23478
    23482
    23486
    23490
    23494
    23498
    23502
    23506
    23510
    5
    23450
    23454
    23458
    23462
    23466
    23470
    23474
    23478
    23482
    23486
    23490
    23494
    23498
    23502
    23506
    23510
    6
    23451
    23455
    23459
    23463
    23467
    23471
    23475
    23479
    23483
    23487
    23491
    23495
    23499
    23503
    23507
    23511
    7
    23451
    23455
    23459
    23463
    23467
    23471
    23475
    23479
    23483
    23487
    23491
    23495
    23499
    23503
    23507
    23511
    8
    23452
    23456
    23460
    23464
    23468
    23472
    23476
    23480
    23484
    23488
    23492
    23496
    23500
    23504
    23508
    23512
    9
    23452
    23456
    23460
    23464
    23468
    23472
    23476
    23480
    23484
    23488
    23492
    23496
    23500
    23504
    23508
    23512
    10
    23453
    23457
    23461
    23465
    23469
    23473
    23477
    23481
    23485
    23489
    23493
    23497
    23501
    23505
    23509
    23513
    11
    23453
    23457
    23461
    23465
    23469
    23473
    23477
    23481
    23485
    23489
    23493
    23497
    23501
    23505
    23509
    23513
    12
    Reply With QuoteRegister To Reply
  11. 02-06-2016, 05:20 PM #11
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Re: Need some help with duplicate numbering data merge

    Almost forgot....
    It would really help to have a "clear cells" function (with or without CLEAR button) if I need to edit quantities on the fly...
    Thanks so much for your help on this!
    Reply With QuoteRegister To Reply
  12. 02-06-2016, 05:21 PM #12
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Re: Need some help with duplicate numbering data merge



    Great job guys!
    Reply With QuoteRegister To Reply
  13. 02-06-2016, 05:43 PM #13
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Hi Kevin

    Both of these are easily dealt with...no Button required.

    This simply requires an additional User Input...
    Can we add something that will populate the header row with the number of pads (PAD1, PAD2 etc etc)?
    This should have been part of the Code I provided...
    It would really help to have a "clear cells" function
    Do you want them...
    to impress the boss and co-workers
    Reply With QuoteRegister To Reply
  14. 02-06-2016, 06:20 PM #14
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Re: Need some help with duplicate numbering data merge

    Really I just want to make the job easier and streamlined.
    No buttons required....
    Will look at the code and try to figure out the clear function...
    Would love the additional user input to add the pad # rows.
    Thanks
    Reply With QuoteRegister To Reply
  15. 02-06-2016, 06:28 PM #15
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Hi Kevin

    I'll look at it after dinner or tomorrow. Both changes are rather direct.
    Reply With QuoteRegister To Reply
  16. 02-06-2016, 08:42 PM #16
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Hi Kevin

    Finished dinner...try this Code in the attached CTRL + x will fire the Code.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  17. 02-06-2016, 11:01 PM #17
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Thumbs up Re: Need some help with duplicate numbering data merge

    Hats off to you jaslake...
    You da man!
    If interested, I am attaching 2 of the pdfs generated from the data merge.... only including pad 01 and pad 10 so I won't bore anyone.
    Also included is the csv file (generated from the .xlsm you provided for me). The InDesign file (for anyone struggling with something like this) can be downloaded HERE. I did not include the linked images to the ID file.

    Thanks so much bro...
    GO BUCKS!

    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  18. 02-06-2016, 11:05 PM #18
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Re: Need some help with duplicate numbering data merge

    atwood lake.jpg

    Looks real nice there!
    Catch any fish? BET
    Reply With QuoteRegister To Reply
  19. 02-07-2016, 12:01 AM #19
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Hi Kevin

    You looked it up...I appreciate that. Fishing is pretty good...primarily saugeye, crappie, bass and cat fish. Go Bucks...

    atwood%20lake.jpg
    Reply With QuoteRegister To Reply
  20. 02-10-2016, 07:58 PM #20
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Re: Need some help with duplicate numbering data merge

    Hey guys.
    Hope all is well this week.
    Been getting some snow again here in Middle Tennessee.
    Got a question...
    How would I edit the macro in the workbook to run the column numbers without duplicates.... ie 1000,1001,1002 etc etc.
    Been lookin at the code and can't quite figure it out.
    Here is the snippet...
    Please Login or Register  to view this content.
    Attached is the file. --> 03doubles-rows-columns.xlsm
    Thanks for your help.
    Reply With QuoteRegister To Reply
  21. 02-11-2016, 08:57 PM #21
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Hi Kevin

    You don't want Dups as in your original requirement?

    Try this...

    Please Login or Register  to view this content.
    Last edited by jaslake; 02-12-2016 at 09:19 PM.
    Reply With QuoteRegister To Reply
  22. 02-13-2016, 12:11 AM #22
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Wink Re: Need some help with duplicate numbering data merge

    ok... I see where I goofed up.

    in this part, I wasn't using my parenthesis properly...
    with dupes...
    Please Login or Register  to view this content.
    with no dupes...

    Please Login or Register  to view this content.

    messed up here... like this...

    Please Login or Register  to view this content.
    and so on ...
    where there is the "ans" division & Lr addition.

    I see where the dupes are created now.
    So I am going to try trips and see if I am correct.
    Thanks so much for the help.
    Will let ya know.
    Reply With QuoteRegister To Reply
  23. 02-13-2016, 12:35 AM #23
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Need help let me know.

    You may wish to have another ans3...how many Dups...
    Reply With QuoteRegister To Reply
  24. 02-14-2016, 12:15 PM #24
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need some help with duplicate numbering data merge

    Hi Kevin

    Per your PM this Code in the attached will provide you with a "universal" approach to create your Pads with single or multiple Ticket Numbers. Simply answer four questions:
    1. How may Pads?
    2. What's the Starting Number?
    3. How many duplicates of each Number?
    4. How many Sheets in each Pad?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  25. 02-14-2016, 06:52 PM #25
    kevindowney
    kevindowney is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Tennessee
    MS-Off Ver
    2010
    Posts
    59

    Re: Need some help with duplicate numbering data merge

    Amazing!
    Thank you kindly sir.
    I will study the latest version, and thanks to the comments, hopefully I will learn something new!
    Take care
    KD
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete duplicate and merge data in one row
    By fnjtravel in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 11-30-2011, 04:42 PM
  2. Mail merge from duplicate data
    By aerovez in forum Excel General
    Replies: 1
    Last Post: 04-25-2011, 02:19 PM
  3. sequential numbering duplicate data
    By mlopardo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2010, 04:11 PM
  4. sequential numbering duplicate data
    By mlopardo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2010, 03:44 PM
  5. sequential numbering of duplicate data
    By 3mlokki in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-26-2010, 07:15 PM
  6. Excel 2007 : Merge duplicate data
    By jeffrowhm in forum Excel General
    Replies: 1
    Last Post: 02-10-2010, 12:40 PM
  7. Merge Duplicate data
    By dirkdd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2009, 05:44 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1