View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric_in_EVV[_2_] Eric_in_EVV[_2_] is offline
external usenet poster
 
Posts: 20
Default generic use of sheet name in user-defined function

I have a workbook that has a separate sheet for each employee. I need to
write a function that sums certain cells based on meeting certain criteria
for each employee. The layout of each employees sheet is identical. How can
I write the function so it will generically use the sheet name in the forumla
as opposed to having to spell it out ?