Guys and girls,
I was wondering if this is even possible but what i have been trying to do is compare cells A1:B6 with the same range in another workbook and if they match transfer the value from that colum c same line to the main workbook.
What i have tryed so far is:
activate a workbook try to set variables and activate another workbook set variable and compare those (did not work)
compare a variable to a cell in a different workbook and grab the value (did not work)
then i copyed some code from the internet and lost my own work..
Could you help me out or gimme a direction?
Regards
Syres
I was wondering if this is even possible but what i have been trying to do is compare cells A1:B6 with the same range in another workbook and if they match transfer the value from that colum c same line to the main workbook.
What i have tryed so far is:
activate a workbook try to set variables and activate another workbook set variable and compare those (did not work)
compare a variable to a cell in a different workbook and grab the value (did not work)
then i copyed some code from the internet and lost my own work..
Could you help me out or gimme a direction?
Regards
Syres