JoelDodenhoff
New Member
- Joined
- Apr 18, 2008
- Messages
- 4
Hello,
I have a workbook for keeping track of invitees to a corporate event. There are 8 sheets, 7 of which are named for individual executives and contain the names of who they would like to invite, their locations, and departments. The remaining worksheet is where I would like to have the ranges of text from each worksheet consolidated into one list.
I have each worksheet's range of invitees named.
How would I go about taking the range names from sheets 2-8 and consolidating them into one list on sheet 1?
Thank you.
I have a workbook for keeping track of invitees to a corporate event. There are 8 sheets, 7 of which are named for individual executives and contain the names of who they would like to invite, their locations, and departments. The remaining worksheet is where I would like to have the ranges of text from each worksheet consolidated into one list.
I have each worksheet's range of invitees named.
How would I go about taking the range names from sheets 2-8 and consolidating them into one list on sheet 1?
Thank you.
