+ Reply to Thread
Results 1 to 6 of 6

Create sets of data (repetitive copy-paste)

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    3

    Create sets of data (repetitive copy-paste)

    sample.xlsm

    Hello,

    Macro novice here, have work mostly on basic copy-paste codes but not the complex ones.

    Been working on a working file with several parameters and would need to create several sets on the results sheet.

    For example, I want to see on the result sheet, for each location:
    1) Each "structure" code has to be assigned with each "Biz" code (so let's say one structure ID has a counterpart of 5 "Biz" codes.

    Please see example result in the file's "results" sheet.

    This has to be done for all locations so I was wondering how a code can be applied to this.

    Thanks in advance!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,405

    Re: Create sets of data (repetitive copy-paste)

    Here, try this:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,370

    Re: Create sets of data (repetitive copy-paste)

    option
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-28-2012
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Create sets of data (repetitive copy-paste)

    Thank you very much zbor. This is the macro I need! However, I just need the minor problem comes when the parameters are not of the same numbers or values (i.e. 8 Location IDs, 6 Structure ID, 10 Biz codes).
    The result shows blanks, and there's a case that not all biz codes will be reflected.
    sample2.xlsm

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,405

    Re: Create sets of data (repetitive copy-paste)

    You can delete entire row with blank cells:

    Please Login or Register  to view this content.
    Last edited by zbor; 08-28-2012 at 04:29 AM.

  6. #6
    Registered User
    Join Date
    08-28-2012
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Create sets of data (repetitive copy-paste)

    works flawlessly! Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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