| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA code for Extracting Data but order of columns changes all the
I have a standard template with fields (worksheet 1) that I need to populate
data with from another worksheet (worksheet 2). The problem is in worksheet 2 the order of the columns will always be different or sometimes the column name may not exist. Is there a vba code that will compare the column headings of worksheet 1 and 2 and if the heading exists in worksheet 2, then that matching column in worksheet 1 will be populated? There are approximately 30 columns in worksheet 1 to populate. any help is much appreciated!! Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting 1st 3-digits of postal code that begin with 0 | Excel Worksheet Functions | |||
| extracting data from a spreadsheet by searching on columns | New Users to Excel | |||
| Extracting data from two columns | Excel Discussion (Misc queries) | |||
| Extracting data from other columns | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Threaded Mode
