LinkBack URL
About LinkBacks
lvl-48 
If you have different random sheet names then use daffodil11's suggestion and create a list of the sheet names.
If you're going to add new sheets then the best option is to use daffodil11's suggestion but make the sheet list a dynamic range.
If you have different random sheet names then use daffodil11's suggestion and create a list of the sheet names.
If you're going to add new sheets then the best option is to use daffodil11's suggestion but make the sheet list a dynamic range.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Lord Valko likes my idea! I'll remember this forever.
Just be sure to convert the list of Sheet names to a table so that the named reference automatically adjusts.
Well, you knew the best answer had to come from PA!
I'll also throw some rep your way!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks