Hi all,
Please can you help me with a code which will return text "P", "W", "N" and "GB" in columns A, B, E and F respectively. (input starts from Row 5) in Sheet 2 if column B in Sheet 1 (range starting from Row 2 - Row 1 has heading) has a value. If Column B has no value the returned field in Sheet 2 in the respective columns will be empty.
Thanks in advance.
Please can you help me with a code which will return text "P", "W", "N" and "GB" in columns A, B, E and F respectively. (input starts from Row 5) in Sheet 2 if column B in Sheet 1 (range starting from Row 2 - Row 1 has heading) has a value. If Column B has no value the returned field in Sheet 2 in the respective columns will be empty.
Thanks in advance.