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
Bookmarks