Hi,

I have a problem. I have 2 sheets in a spreadsheet, "sheet1" and
"sheet2", in sheet 1 i have 2 columns A and B, in Sheet2 i have also 2
columns A and B.
Sheet1.column A is a customer number. Sheet2.column A is also a
customer number. Sheet1column b is empty. I need to fill this empty
column with sheet2.column B, when each cell in sheet 1 and 2 column A
are equal. What is the best way to do this with VB or directly in
Excel.