Hi.
I have a book with 12 sheets, one per month of the year.
On each sheet I have the person on duty for each day of that respective month.
I need to vlookup all of the 12 months(sheets) so that I can have on a different book a cell that tell's me who's on duty.
I know a formula that does this, but only for 6 sheets, is is possible to vlookup all the 12 months?
Thanks alot!
I have a book with 12 sheets, one per month of the year.
On each sheet I have the person on duty for each day of that respective month.
I need to vlookup all of the 12 months(sheets) so that I can have on a different book a cell that tell's me who's on duty.
I know a formula that does this, but only for 6 sheets, is is possible to vlookup all the 12 months?
Thanks alot!