Feb 26 2019 10:21 PM
Hi
I have the master record in sheet 1.
I want to copy certain rows from sheet 1 to sheet 2 if condition is met.
Sheet 1
Column B - department code
Column C - Department Description
Column D - Employee Number
Column E ..... and so on
see image
Now, in Sheet 2, I want to copy all rows if the dept code is 0000.
Can somebody help me? I am a newbie in excel. Thanks
Feb 26 2019 11:40 PM
SolutionFeb 26 2019 11:40 PM
Solution