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!
|