View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pontificateur Pontificateur is offline
external usenet poster
 
Posts: 13
Default Pull data from inactive worksheet

Hi, all.

I've perused the threads and found nothing on the following (likely because
it's evident to everyone else!), and would like your help.

I have two worksheets, "Employees" and "Summary", in the same workbook.
When a user selects the Summary sheet and clicks a refresh button, I need to
grab the employee number from the row they had selected on the Employees
sheet. I cannot use ActiveCell, since Summary is now the active sheet.

What am I missing?

Thanks!