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.
Bookmarks