Hi All
I've giving up trying to work this one out. Can someone help me please?
I have two worksheets in a workbook
On the first worksheet sheet I have:
Column A (Account Code) and Column B (Address Code) Column C (wanting the address ref from second worksheet)
On the second worksheet I have 3 columns:
Column A (Account Code) and Column B (Address Code) Column C (Address Ref)
If the account code and address code match put the address ref in column C on first workbook?
I do hope I have explained myself.
Could anyone please help?
Kind regards
Peter
I've giving up trying to work this one out. Can someone help me please?
I have two worksheets in a workbook
On the first worksheet sheet I have:
Column A (Account Code) and Column B (Address Code) Column C (wanting the address ref from second worksheet)
On the second worksheet I have 3 columns:
Column A (Account Code) and Column B (Address Code) Column C (Address Ref)
If the account code and address code match put the address ref in column C on first workbook?
I do hope I have explained myself.
Could anyone please help?
Kind regards
Peter