Greetings to the expert!
I'm a novice in visual basic macro and would like to seek help from the experts. Pls kindly help me with it, thank you in advance.
These are some sample data:
In my source.xls, i have 2 columns of data with value as shown below:
Functions | Business Positions
Procurement Manager
And i want a macro that runs like that:
When the value e.g. in range("A2") under column "Functions" = "Procurement"
AND values e.g. in range ("B2") under column "Business Positions" = "Manager"
THEN, it will direct to the workbook procurement.xls
I had tried to use IF..ELSE statement but to no avail.
Please guide me on this.
Thank you very much
Your help will be greatly appreciated
Best regards,
htoh2
I'm a novice in visual basic macro and would like to seek help from the experts. Pls kindly help me with it, thank you in advance.
These are some sample data:
In my source.xls, i have 2 columns of data with value as shown below:
Functions | Business Positions
Procurement Manager
And i want a macro that runs like that:
When the value e.g. in range("A2") under column "Functions" = "Procurement"
AND values e.g. in range ("B2") under column "Business Positions" = "Manager"
THEN, it will direct to the workbook procurement.xls
I had tried to use IF..ELSE statement but to no avail.
Please guide me on this.
Thank you very much
Your help will be greatly appreciated
Best regards,
htoh2