Hi All,
Appreciate if you can please help me resolving following issue I am facing.
I have set of two work books with data
Work Book 1:
<colgroup><col><col span="7"></colgroup><tbody>
</tbody>
Work Book2:
<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>
Above data is for Balance Sheet and P&L of various companies. But column order is usually different (but both work books are having information related to same companies) making it difficult to just copy and pasting the information of same company under each other. So I have to manually first bring them in same order so that I can just copy paste and bring balance sheet and P&L in same order. There might be instances where one or two companies are not present in any set of data(i.e work book)
Is there any way to automate this to avoid one whole day work. For me due to so many business units take a lot of time to manually adjust them.
Appreciate if you can please help me resolving following issue I am facing.
I have set of two work books with data
Work Book 1:
HOI | CITIK | OISCO | MITEL | SOFT | YBRW | AMA | |
Fixed Assets | 1 | 2 | 45 | 5 | 5 | 45 | 45 |
Current Assets | 3 | 4 | 5 | 5 | 5 | 5 | 5 |
Long term Liabilities | 4 | 5 | 1 | 5 | 5 | 1 | 1 |
Short term liabilities | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
Equity | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
<colgroup><col><col span="7"></colgroup><tbody>
</tbody>
Work Book2:
YBRW | HOI | OISCO | ALVIRO | MITEL | SOFT | CITIK | AMA | |
Sales | 45 | 1 | 45 | 10 | 5 | 5 | 2 | 45 |
COST | 5 | 3 | 5 | 8 | 5 | 5 | 4 | 5 |
Margin | 1 | 4 | 1 | 2 | 5 | 5 | 5 | 1 |
Admin Exp | 5 | 5 | 5 | 1 | 5 | 5 | 5 | 5 |
Profit | 5 | 5 | 5 | 1 | 5 | 5 | 5 | 5 |
<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>
Above data is for Balance Sheet and P&L of various companies. But column order is usually different (but both work books are having information related to same companies) making it difficult to just copy and pasting the information of same company under each other. So I have to manually first bring them in same order so that I can just copy paste and bring balance sheet and P&L in same order. There might be instances where one or two companies are not present in any set of data(i.e work book)
Is there any way to automate this to avoid one whole day work. For me due to so many business units take a lot of time to manually adjust them.