Each employee has a separate tab in the spreadsheet with their own details in
it...I'm trying to put together a separate tab that has a one line summary
for each employee. The separate tabs have the employee name as the tab
name...can I use the employee name (generically) in column A in the summary
sheet in a formula to pull info back from each employees detailed sheet ?

I want the summary sheet to look something like this:

Employee Name Annual Allotment Total Points Incurred
Smith, Joe 12 0

with the annual allotment and total points incurred being formula driven by
looking up the info from the employee name listed....how do I use "Smith,
Joe" generically (column A, row ##) in a formula to grab data from specific
cells a separate tab named "Smith, Joe" ??

Does that make any sense ?

Thanks for any advice !

=COUNTA(INDIRECT("'"&A2&"'!A:A"))

"Eric_in_EVV" wrote:

Each employee has a separate tab in the spreadsheet with their own details in
it...I'm trying to put together a separate tab that has a one line summary
for each employee. The separate tabs have the employee name as the tab
name...can I use the employee name (generically) in column A in the summary
sheet in a formula to pull info back from each employees detailed sheet ?

I want the summary sheet to look something like this:

Employee Name Annual Allotment Total Points Incurred
Smith, Joe 12 0

with the annual allotment and total points incurred being formula driven by
looking up the info from the employee name listed....how do I use "Smith,
Joe" generically (column A, row ##) in a formula to grab data from specific
cells a separate tab named "Smith, Joe" ??

Does that make any sense ?

Thanks for any advice !

check out the INDIRECT function. To return the sum of A1:A10 on sheet "Smith,
Joe" you can do this:

=SUM(INDIRECT("'"&A2&"'!A1:A10"))

Note that in this formula, since A1:A10 are enclosed in qutation marks, they
will not change if you copy the formula left/right.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eric_in_EVV" wrote:

Each employee has a separate tab in the spreadsheet with their own details in
it...I'm trying to put together a separate tab that has a one line summary
for each employee. The separate tabs have the employee name as the tab
name...can I use the employee name (generically) in column A in the summary
sheet in a formula to pull info back from each employees detailed sheet ?

I want the summary sheet to look something like this:

Employee Name Annual Allotment Total Points Incurred
Smith, Joe 12 0

with the annual allotment and total points incurred being formula driven by
looking up the info from the employee name listed....how do I use "Smith,
Joe" generically (column A, row ##) in a formula to grab data from specific
cells a separate tab named "Smith, Joe" ??

Does that make any sense ?

Thanks for any advice !