+ Reply to Thread
Results 1 to 8 of 8

Please Help! Tricky Big Data Reorganization

  1. #1
    Registered User
    Join Date
    07-27-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Please Help! Tricky Big Data Reorganization

    Full disclosure:
    -I am completely new to this forum so bear with me
    -I am confident in my excel formula skills but have zero VB knowledge
    -I am working in Excel 2010

    I have a workbook with a large number of paired sheets. Each pair has an "entry sheet" and "upload sheet."



    The entry sheet:

    Each entry sheet is designed so that data can be entered to a number of user friendly fields on the sheet and the corresponding upload sheet populates the entries so that they can be uploaded to a database.


    The upload sheet:
    The upload sheets composed of a list in column A with a short descriptive tag for each entry, column B is a space where, if the user puts an "x" in the cell, the lookup function will pull the corresponding data, using an ID code in column C, to match the correct entry from the entry sheet. The columns to the right of C are spaces to store (copy and paste) the data pulled from the entry sheet over the past few days.


    The problem is:

    The list on each upload sheet is NOT uniform. Some sheets have different ordering or have rows I do not need.
    I would like to be able to make one standardized list, copy and paste it across all upload sheets and have each old upload reorganize the rows into the new standardized column A...

    I am open to any ideas that can make all or any part of this process easier than manually editing each sheet individually, VB included but please lay on generous levels of help on VB suggestions.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Please Help! Tricky Big Data Reorganization

    Hello and welcome to the forums!

    Sounds like something you could accomplish with rank - match - index to autopopulate the uploads.

    If you can upload a sample of your work, I'll gladly take a crack at it.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,243

    Re: Please Help! Tricky Big Data Reorganization

    Hi and welcome to the forum

    1st, I would question the need for a bunch of different "input" sheets, and their paired "output" sheets?

    Would it not be simpler to have 1 "data" sheet for all data entry, and then 1 "extract" sheet to pull out what you need? Then you only have 1 sheet to mess with, if you need to change things
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    07-27-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Please Help! Tricky Big Data Reorganization

    Hi daffodil11, I have attached a boiled down version of my sheet. The "upload sheet" has the new list I would like to use in column A next to the old list in column B with all the corresponding data in the columns thereafter.


    @FDibbins, your suggestion makes perfect sense however my hands are tied by the database and I am required to keep the upload sheets separate (though im hoping that my new standardizes formatting helps push for one upload sheet!)


    Rearrange Help.xlsx

  5. #5
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Please Help! Tricky Big Data Reorganization

    Wow, what did I step in?

    Paraphrasing for understanding:
    It looks like you're trying to apply the new row headers you've added to the Upload Sheet, and have the existing rows rearrange to fit them?

  6. #6
    Registered User
    Join Date
    07-27-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Please Help! Tricky Big Data Reorganization

    your exactly right daffodil11. Now you see why I've reached out for help...

  7. #7
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Please Help! Tricky Big Data Reorganization

    You might want to check the VB forum. It looks like you need to do an index-match, but instead of reorganizing one cell at a time you need to reorganize entire rows.

  8. #8
    Registered User
    Join Date
    07-27-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Please Help! Tricky Big Data Reorganization

    Alright ill pick some brains over there. Thanks for your help!

+ 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. Excel Table reorganization
    By 2asela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2011, 03:39 PM
  2. Complex data reorganization question
    By lgamtech in forum Excel General
    Replies: 5
    Last Post: 09-09-2011, 07:42 PM
  3. [SOLVED] Tricky data type error
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2006, 08:00 PM
  4. Worksheets reorganization and formatting
    By Cfox in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-12-2005, 10:18 AM

Tags for this Thread

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