Worksheet question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I posted this question earlier but didn't get the right answer...so can I try again

Basically I have a list of employee and their leave details as below on a 'front sheet' worksheet

A B C
1 FirstName Surname Ref Leave Remainin
2 John Smith
3 Ian Lang
4 Tim Robbins

Each individual has their own worksheet ( called FirstnameSurnameref, i.e JohnSmith1) where further leave details are, including leave allocated and leave taken. And a cell which is simply leave remaining (A20). What I want to do is on the front sheet (i.e. the one above) fill in the leave remaining column using a relative formula, such as =A2&AB2&C2!A20, which I can drag down to all the employees.

Any ideas

Help is always appreciated.
 
Use =INDIRECT(A2&B2&C2&"!A20")

--
David Hager
Excel MVP

Kevin said:
Hi,

I posted this question earlier but didn't get the right answer...so can I try again?

Basically I have a list of employee and their leave details as below on a 'front sheet' worksheet;

A B C D
1 FirstName Surname Ref Leave Remaining
2 John Smith 1
3 Ian Lang 2
4 Tim Robbins 3

Each individual has their own worksheet ( called FirstnameSurnameref, i.e
Click to expand...
JohnSmith1) where further leave details are, including leave allocated and
leave taken. And a cell which is simply leave remaining (A20). What I want
to do is on the front sheet (i.e. the one above) fill in the leave remaining
column using a relative formula, such as =A2&AB2&C2!A20, which I can drag
down to all the employees.
 
Back
Top