+ Reply to Thread
Results 1 to 3 of 3

Copy and paste dynamic ranges + transforming into a table

  1. #1
    Registered User
    Join Date
    06-29-2013
    Location
    bla
    MS-Off Ver
    Excel 2003
    Posts
    2

    Copy and paste dynamic ranges + transforming into a table

    Hello excel users.

    I am trying to create a more robust copy and paste macro.
    Basically, every day I receive 2 - 3 reports with users I have to create, move to other domains and users I have to expire, this reports contain about 50 - 70 columns of info, of which I need 2 - 4. What I am trying to do is create a macro that does basically this:

    Search for a column name (for example "name").
    Copy and paste the "name" column into a different sheet.
    Create a formated table (keep in mind the number of users changes so this has to be dynamical also)
    I am providing 2 workbooks as example, the info in red is the one that I need. First is a mookup with what I start and the second is where I want to end up.
    Example1.xlsxExample2.xlsx

    Thanks for any help.
    Last edited by tigerallied; 06-29-2013 at 01:08 PM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Copy and paste dynamic ranges + transforming into a table

    I thought you only wanted to find the name column, copy/paste that and then convert into table.

    In your 2nd workbook you have 3 tables, the first with 2 columns (name and surname), the 2nd and third with 3 columns (name, surname and random_info4/2).

    Do you actually want to take the data from each worksheet (Mutari, Creeari and Expirari)?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    06-29-2013
    Location
    bla
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Copy and paste dynamic ranges + transforming into a table

    To answer the question in one single word, yes. I am kinda bad at explaining, sorry about that. I pretty much want to consolidate the info I need into one sheet.

    The biggest problems I have are creating the dynamic selects since the number of users can very from 0 to 500.
    If the placing of the tables one under another is to complicated / time consuming, they can be put one next to each other.

    Thank again for any help
    Last edited by tigerallied; 06-29-2013 at 04:57 PM.

+ 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