J
jkrons
I have this formula to handle a view of weekly bookings.
=IF(ISERROR(MATCH($A15,Forgings!E$3:E$14,0)),"",OFFSET(Forgings!E3,0,3-
COLUMN(E3)))
It looks in a specific sheet, "Forgings" til see, whether a certain
person is booked on a certain project i a given week. If he is, it
returns the customer for which he is booked. This works perfectly OK
and formula is copied to other personons and other weeks.
The challenge is, that I would like my overview sheet to show any
bookings, no matter which project, the person is booked for. The
problem is, that each projct has its own sheet. These are all alike.
I have right now 8 projectsheets, but this number will grow, so I
would like a formula, that "looks in" all the sheets, also in later
added sheets without me having to add to the formula.
=IF(ISERROR(MATCH($A15,Forgings!E$3:E$14,0)),"",OFFSET(Forgings!E3,0,3-
COLUMN(E3)))
It looks in a specific sheet, "Forgings" til see, whether a certain
person is booked on a certain project i a given week. If he is, it
returns the customer for which he is booked. This works perfectly OK
and formula is copied to other personons and other weeks.
The challenge is, that I would like my overview sheet to show any
bookings, no matter which project, the person is booked for. The
problem is, that each projct has its own sheet. These are all alike.
I have right now 8 projectsheets, but this number will grow, so I
would like a formula, that "looks in" all the sheets, also in later
added sheets without me having to add to the formula.