+ Reply to Thread
Results 1 to 3 of 3

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.


    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. I am trying to apply the new row headers you've added to the Upload Sheet, and have the existing rows rearrange to fit them?


    Rearrange Help.xlsx

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Please Help! Tricky Big Data Reorganization

    Duplicate post

    http://www.excelforum.com/excel-gene...anization.html

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

    Re: Please Help! Tricky Big Data Reorganization

    ?? that was my question which was directed to this thread from the general excel thread. Did i do something wrong?

+ 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. Please Help! Tricky Big Data Reorganization
    By dasslink in forum Excel General
    Replies: 7
    Last Post: 08-12-2013, 10:11 AM
  2. Excel Table reorganization
    By 2asela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2011, 03:39 PM
  3. Complex data reorganization question
    By lgamtech in forum Excel General
    Replies: 5
    Last Post: 09-09-2011, 07:42 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