Hi,
I need to do this but i don't know how, if you can please help, Let' me explain.
I have in a workbook with 3 sheets, in the first sheet in column E i have a number of asset, in the same worksheet in column Q i'have the status of that asset if it is installed or is in stock.
In another sheet i have the same but the status of some assets is diferent because they were installed.
What i want to compare is the status of assets bewteen the 1 sheet and the 2 one.
Best Regards, and please help
Worksheet 1
<TBODY>
</TBODY>
I need to do this but i don't know how, if you can please help, Let' me explain.
I have in a workbook with 3 sheets, in the first sheet in column E i have a number of asset, in the same worksheet in column Q i'have the status of that asset if it is installed or is in stock.
In another sheet i have the same but the status of some assets is diferent because they were installed.
What i want to compare is the status of assets bewteen the 1 sheet and the 2 one.
Best Regards, and please help
Worksheet 1
Column A | Column B | Column E | Column F | Column Q |
223355 | Stock | |||
223345 | Installed | |||
223465 | Stock | |||
223769 | Stock | |||
222222 | Installed | |||
Worksheet 2 | ||||
Column A | Column B | Column E | Column F | Column Q |
223355 | Abate | |||
223345 | Installed | |||
223465 | Stock | |||
223769 | Installed | |||
222222 | Installed |
<TBODY>
</TBODY>