Community archive

Ask something
Discussion Locked

excel question

0 helpful
1 reply

by hilalpaksoy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi everyone
i am sure it s easy but i dont know how to do it.

i am making 7 tables (excel sheets) for 7 groups working in the building to see the times people are having off sick,holiday,overtime...etc.

the question is i want to make another main sheet to see everything on that and when i make a change in one of the 7 sheets i want it to be done in the main sheet automatically.i can use formulas and things but ie. i paint the cells to grey to show people`s holiday.how that grey can also be shown in the main sheet in the right place?? is there any formula for that???

thanks in advance.............

1 reply

by 1231

I'm not exactly sure HOW you are doing it, but look at conditional formatting. You can construct test such as if(a5>1,true,false) and set the attributes of the cell to be white on false (in attendance) or grey on true (on vacation).

I'd also suggest using named areas for each employee's schedule. It's a pain to set up, but easier to maintain.

This discussion is closed to new replies.