I have 2 sheets. in Sheet 1 there are some codes in 6 columns (G,H,I,J,K,L). And Sheet 2 contains codes (column A) and their full names (column B).
I need a macro which will find each codes in G,H,I,J,K,L in Sheet 2 column A and take its full name in column B and replace full name with its code in Sheet 1.
Since list is variable makro also should check blw situations
* Row address where codes are starting is variable. But the easiest way to find it, to find first full cell in column G and add 2 row down (i.e. if first full cell is G15, codes are starting from G17, H17,I17, etc).
* One of G,H,I,J,K,L cells may be empty. if any, pass next one (i.e. if G20 is empty, check H20. if it is also empty check I20)
* End of list. Since G,H,I,J,K,L cells may be empty, end of the list can be controlled from column A. All cells in column A is full and last cell contains a charachter as "" but this row does not contain any code !!!
thanks fr yr assist.
I need a macro which will find each codes in G,H,I,J,K,L in Sheet 2 column A and take its full name in column B and replace full name with its code in Sheet 1.
Since list is variable makro also should check blw situations
* Row address where codes are starting is variable. But the easiest way to find it, to find first full cell in column G and add 2 row down (i.e. if first full cell is G15, codes are starting from G17, H17,I17, etc).
* One of G,H,I,J,K,L cells may be empty. if any, pass next one (i.e. if G20 is empty, check H20. if it is also empty check I20)
* End of list. Since G,H,I,J,K,L cells may be empty, end of the list can be controlled from column A. All cells in column A is full and last cell contains a charachter as "" but this row does not contain any code !!!
thanks fr yr assist.