What I have is a list of names, and a value beside it. Each name has it's
own sheet within the workbook. I'm trying to call a macro/
VB script in order
for it to go to the worksheet I need, pull the info and put it into the value
beside the name in the list. If I hard code the name itself, I can get it to
go to the worksheet, pull the information I need and put it back on the first
worksheet. But how can I say "Go to the worksheet with the name in this
cell"?
Sheets("Nicole").Activate - works
Sheets(ActiveCell.Value).Activate - is what I want to do - but it's not
working. What's in the "quotes" I want to populate with the name in the cell.
How do I do this? CAN I do this, or am I just crazy? :) Any help will be
appreciated.