If sheet 1 column 4 says hol then it fills in columns A1,B1 and [Closed]

Report
Posts
4
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
February 12, 2014
-
 Blocked Profile -
Hello,
I have 2 sheets in excel 1st sheet has:
1st column has employee Team A1
2nd column has employee number B1
3rd Column has Employee name C1
4th column has HOL or shift pattern D1

The second sheet has 3 columns
A1 = employee team
b1 = employee number
c1 = employee name

What I want to do is if sheet 1 column 4 says hol then it fills in columns A1,B1 and C1 on sheet 2 with the info from sheet 1

Regards

scarey

1 reply


Scarey,

I hope I am not doing homework!

ok, hang tight!
if function: =if(logic_test,true, false)

So, let us look at the first thing:address.




So then, take that function, click on the cell, and drag it down [notice the address locations changes are relative to the cell that is calling it]. The function always needs to see if qualitying cell has HOL.

It will transfer the blank lines, so if line 12 has HOL, then line 12 on second sheet is filled, it DOES NOT LOOK FOR NEXT ROW on second sheet! What do you want for free? :)

Let us know if this helps.

Have Fun!
//ark
-Moderator/Contributor

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!