Macro Excel VBA to verify if cell not empty
Posted on 2014-12-30
I need your help in order to:
verify if the cell A1 is empty, if not, apply the vlookup function, if yes, stop.
Not to sure how to explain. Column A has around 23000 cells with data (next month it could be more, it could be less).
Column B should is a vlookup result if cell A is not empty: if cell Axx not empty, then apply the vlookup, else, nothing
I need to repeat this for many column... check if cell A is empty, if not the apply the vlookup, else, nothing...
Is this possible? I am trying to automate as much as possible an Excel Spreadsheet that will, at the end, create a "Table" will all pc information i need from different CSV files.