Excel formula

Occasional Visitor



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

1 Reply
Assuming your data in Sheet1 is from Column B:F and the layout of Sheet1 is the same as Sheet2, the formulas you need in Sheet2 are:
After copying D1 down the rows, you then copy B1 to C1, E1:F1, and down such rows also.
Related Conversations
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Help with minutes/seconds to seconds.
SteveMorley in Excel on
1 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies