I want to Create a Macro that will search for a Column Header on a source
spreadsheet, match that with an Indentically named Columnheader on
spreadsheet I use as a template, then take the information in the cells below
the header in the source spreadsheet and move it to the template.
the sticky parts are as followes.
1. have to do this for about 11 Columns but some of the headers on the
template will not appear on the Source. 5 are absolutely necessary and the
other 6 are optional.
2. I need to search for the header names because they may not be in the
right order, and worse they may not be in the first row. still worse 2 of the
header names have a tendency of being duplicated in different columns with
different information, but i still them.
3. there can be anywhere from two to 100 rows of information.
4. I have some formulas I would like to Automatically populate the correct
number of cells.
I know this sounds like alot but I can't imagine that no one has ever tried
to do this or something like this before. I have the basic parts down but I'm
struggling with the things I've indicated.
Thanks