As a real estate practitioner (newbie programmer in excel) I receive various
schedules of vacant properties from different property companies.
In each there are column headings, but the same data in each column of the
various schedules is usually headed by similar (but not identical) labels.
Eg in one schedule the heading may be "Area", and in another it would be
"Size", in still in another it could be "square feet".
To make matters worse the order of the columns may be different, i.e. "Area"
could be in col "C" in one schedule, "Size" could be in col "F" of another,
and so on.
Is there any way I could combine all the data from the various schedules
into one master schedule with column headings and positions of my choice? Or
perhaps there is some freeware out there that can do this?
Thanks in advance.
Stan