M
Mas
Hi all,
I am trying to merge three workbooks and worksheets into one and then
have the data sorted automatically in the order of the workbook names.
For example:
I have three workbooks named ... Workbook1, Workbook2, Workbook3 with
one worksheet in each named ... Sheet1.
All three worksheets have column headings with some column headings
being identical in all three worksheets and some columns being unique to
each individual worksheet.
I would like to merge all three workbooks and worksheets into one and
sorted in the order of the workbook names. i.e. merge Workbook1 first,
followed by Workbook2, and last Workbook3, and then to be sorted by the
columns that have identical headings.
For example:
Workbook1 has column headings colour and make
Workbook2 has column headings colour and year
Workbook3 has column headings colour and make and type
I would like for Workbook1 to be merge into a new workbook, then have
Workbook2 merged into the same new workbook and then merge Workbook3
into the same workbook and have the new workbook automatically sorted by
the columns that appear from Workbook1 first, followed by columns that
appeared in Workbook2, and finally Workbook3.
As from the example above: columns to be sorted by colour first
(Workbook1), make (Workbook1), year (Workbook2) and last type (Workbook3).
I hope someone can help although it may be impossible of what I am asking.
Thanks in advance.
Mas
I am trying to merge three workbooks and worksheets into one and then
have the data sorted automatically in the order of the workbook names.
For example:
I have three workbooks named ... Workbook1, Workbook2, Workbook3 with
one worksheet in each named ... Sheet1.
All three worksheets have column headings with some column headings
being identical in all three worksheets and some columns being unique to
each individual worksheet.
I would like to merge all three workbooks and worksheets into one and
sorted in the order of the workbook names. i.e. merge Workbook1 first,
followed by Workbook2, and last Workbook3, and then to be sorted by the
columns that have identical headings.
For example:
Workbook1 has column headings colour and make
Workbook2 has column headings colour and year
Workbook3 has column headings colour and make and type
I would like for Workbook1 to be merge into a new workbook, then have
Workbook2 merged into the same new workbook and then merge Workbook3
into the same workbook and have the new workbook automatically sorted by
the columns that appear from Workbook1 first, followed by columns that
appeared in Workbook2, and finally Workbook3.
As from the example above: columns to be sorted by colour first
(Workbook1), make (Workbook1), year (Workbook2) and last type (Workbook3).
I hope someone can help although it may be impossible of what I am asking.
Thanks in advance.
Mas