Hello all 
I have a problem with creating macro. I'm not familiar with VBA (unfortunately), but I think formulas cannot do the trick.
The problem is that i have two workbooks, e.g. "Reference" and "Data". In "Reference" I have a list of interested computers and in "Data" I have a list of all computers and info in other columns about each computer. What I have to do is to search column which contains name "COMPUTER" (i use ADDRESS and MATCH formulas), compare with name of each computer in "Reference" workbook (VLOOKUP), check is server on both lists, and show additional data in each row.
In "Data" file COMPUTER column do not always have the same address, even the "Data" file may have different name - all addresses have to be chosen manually.
Can someone give me a tip how I can insert variable (or maybe there is other way to do this) into formula, which I can declare earlier in some way?
Thank you in advance!
I have a problem with creating macro. I'm not familiar with VBA (unfortunately), but I think formulas cannot do the trick.
The problem is that i have two workbooks, e.g. "Reference" and "Data". In "Reference" I have a list of interested computers and in "Data" I have a list of all computers and info in other columns about each computer. What I have to do is to search column which contains name "COMPUTER" (i use ADDRESS and MATCH formulas), compare with name of each computer in "Reference" workbook (VLOOKUP), check is server on both lists, and show additional data in each row.
In "Data" file COMPUTER column do not always have the same address, even the "Data" file may have different name - all addresses have to be chosen manually.
Can someone give me a tip how I can insert variable (or maybe there is other way to do this) into formula, which I can declare earlier in some way?
Thank you in advance!
