02-09-2015, 06:28 AM
Greetings,
I need to have 3 things done in excel via QM
1) Using variable 'var1' from QM, I need to find & activate a sheet in excel.
2) Using variable 'var2' from QM, I need to find & select a cell with the 'var2' value in the activated sheet only.
3) Once the cell is found, I need to have the offset(0,-1) value stored in a new QM variable 'var3'.
It is the result in 'var3' that I would be using as the initial input for my previous excel query.
Appreciate your help.
Best Regards,
Philip
I need to have 3 things done in excel via QM
1) Using variable 'var1' from QM, I need to find & activate a sheet in excel.
2) Using variable 'var2' from QM, I need to find & select a cell with the 'var2' value in the activated sheet only.
3) Once the cell is found, I need to have the offset(0,-1) value stored in a new QM variable 'var3'.
It is the result in 'var3' that I would be using as the initial input for my previous excel query.
Appreciate your help.
Best Regards,
Philip
Best Regards,
Philip
Philip