selecting different cell ranges across sheets, to display on summary page

Each workbook sheet has payroll records per individual for the entire
year (regular hours, overtime, holiday etc).

I want a summary sheet to display the relevant data (ie: sums of regular
hours, sick days etc) of the payperiod entered (1 of 26) for each
employee.

So the clerk (me) enters a payroll period, and sees that data for each
employee.

Seems simply enough, and there is probably more than one way to do it,
but the help files have only frustrated me so far.


TIA
--
NetMax

Best way would be to sum them in a nominated cell on each worksheet, lets
say B2, B3, etc and then sum them like

=SUM(Sheet1:Sheet26!B2)

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"NetMax" <[email protected]> wrote in message
news:[email protected]...
> Each workbook sheet has payroll records per individual for the entire
> year (regular hours, overtime, holiday etc).
>
> I want a summary sheet to display the relevant data (ie: sums of regular
> hours, sick days etc) of the payperiod entered (1 of 26) for each
> employee.
>
> So the clerk (me) enters a payroll period, and sees that data for each
> employee.
>
> Seems simply enough, and there is probably more than one way to do it,
> but the help files have only frustrated me so far.
>
>
> TIA
> --
> NetMax
>
>

Don't think that will do it. Somewhere on the summary sheet, I want to
enter a number (corresponding to the payroll period I want the data called
up from). Then all the employee data displayed would be called up from only
a certain location on their individual sheets.

Essentially, regular hours for employee X would be ='empX'!(find payroll
period to direct which cell to copy data from)
then I repeat this for their sick days, holiday etc. Then I repeat the
whole thing per employee.

I need a variable in the equals statement to copy from different cell
addresses.
--
NetMax

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> Best way would be to sum them in a nominated cell on each worksheet, lets
> say B2, B3, etc and then sum them like
>
> =SUM(Sheet1:Sheet26!B2)
>
> etc.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "NetMax" <[email protected]> wrote in message
> news:[email protected]...
>> Each workbook sheet has payroll records per individual for the entire
>> year (regular hours, overtime, holiday etc).
>>
>> I want a summary sheet to display the relevant data (ie: sums of regular
>> hours, sick days etc) of the payperiod entered (1 of 26) for each
>> employee.
>>
>> So the clerk (me) enters a payroll period, and sees that data for each
>> employee.
>>
>> Seems simply enough, and there is probably more than one way to do it,
>> but the help files have only frustrated me so far.
>>
>>
>> TIA
>> --
>> NetMax
>>
>>
>
>

Couldn't the summing formula on each sheet pick up that variable period on
the summary sheet?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"NetMax" <[email protected]> wrote in message
news:[email protected]...
>
> Don't think that will do it. Somewhere on the summary sheet, I want to
> enter a number (corresponding to the payroll period I want the data called
> up from). Then all the employee data displayed would be called up from
only
> a certain location on their individual sheets.
>
> Essentially, regular hours for employee X would be ='empX'!(find payroll
> period to direct which cell to copy data from)
> then I repeat this for their sick days, holiday etc. Then I repeat the
> whole thing per employee.
>
> I need a variable in the equals statement to copy from different cell
> addresses.
> --
> NetMax
>
> "Bob Phillips" <[email protected]> wrote in message
> news:%[email protected]...
> > Best way would be to sum them in a nominated cell on each worksheet,
lets
> > say B2, B3, etc and then sum them like
> >
> > =SUM(Sheet1:Sheet26!B2)
> >
> > etc.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "NetMax" <[email protected]> wrote in message
> > news:[email protected]...
> >> Each workbook sheet has payroll records per individual for the entire
> >> year (regular hours, overtime, holiday etc).
> >>
> >> I want a summary sheet to display the relevant data (ie: sums of
regular
> >> hours, sick days etc) of the payperiod entered (1 of 26) for each
> >> employee.
> >>
> >> So the clerk (me) enters a payroll period, and sees that data for each
> >> employee.
> >>
> >> Seems simply enough, and there is probably more than one way to do it,
> >> but the help files have only frustrated me so far.
> >>
> >>
> >> TIA
> >> --
> >> NetMax
> >>
> >>
> >
> >
>
>

The challenge was making the variable period selectable. I found HLOOKUP &
VLOOKUP solved my problem. Thanks anyways for your help Bob!
regards
--
NetMax

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Couldn't the summing formula on each sheet pick up that variable period on
> the summary sheet?
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "NetMax" <[email protected]> wrote in message
> news:[email protected]...
>>
>> Don't think that will do it. Somewhere on the summary sheet, I want to
>> enter a number (corresponding to the payroll period I want the data
>> called
>> up from). Then all the employee data displayed would be called up from
> only
>> a certain location on their individual sheets.
>>
>> Essentially, regular hours for employee X would be ='empX'!(find payroll
>> period to direct which cell to copy data from)
>> then I repeat this for their sick days, holiday etc. Then I repeat the
>> whole thing per employee.
>>
>> I need a variable in the equals statement to copy from different cell
>> addresses.
>> --
>> NetMax
>>
>> "Bob Phillips" <[email protected]> wrote in message
>> news:%[email protected]...
>> > Best way would be to sum them in a nominated cell on each worksheet,
> lets
>> > say B2, B3, etc and then sum them like
>> >
>> > =SUM(Sheet1:Sheet26!B2)
>> >
>> > etc.
>> >
>> > --
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > (remove nothere from email address if mailing direct)
>> >
>> > "NetMax" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> Each workbook sheet has payroll records per individual for the entire
>> >> year (regular hours, overtime, holiday etc).
>> >>
>> >> I want a summary sheet to display the relevant data (ie: sums of
> regular
>> >> hours, sick days etc) of the payperiod entered (1 of 26) for each
>> >> employee.
>> >>
>> >> So the clerk (me) enters a payroll period, and sees that data for each
>> >> employee.
>> >>
>> >> Seems simply enough, and there is probably more than one way to do it,
>> >> but the help files have only frustrated me so far.
>> >>
>> >>
>> >> TIA
>> >> --
>> >> NetMax
>> >>
>> >>
>> >
>> >
>>
>>
>
>