Mighty Whites
New Member
- Joined
- Sep 18, 2008
- Messages
- 49
Hi,
A couple of questions here which hopefully someone will be able to help me with.....
I have a workbook with a number of tabs in including a 'Master Sheet' in which data is dropped in on a weekly basis (the data which is dropped in is basically feedback for managers). The other tabs in the workbook are titled using these managers names. At present the user has to rename the tabs based on which managers are in the data drop, then has to manually filter each manager and paste the relevant data in to their assigned sheet....note managers can appear on the data drop more than once (i.e. may have 4 pieces of feedback) but only 1 tab would be created.
Is there a way using VB where I can get the tabs to be renamed based on whichever managers are in the 'Master Sheet' and then copy and paste the data in to their sheets?
Hope I've explained this clearly enough.
Thanks
A couple of questions here which hopefully someone will be able to help me with.....
I have a workbook with a number of tabs in including a 'Master Sheet' in which data is dropped in on a weekly basis (the data which is dropped in is basically feedback for managers). The other tabs in the workbook are titled using these managers names. At present the user has to rename the tabs based on which managers are in the data drop, then has to manually filter each manager and paste the relevant data in to their assigned sheet....note managers can appear on the data drop more than once (i.e. may have 4 pieces of feedback) but only 1 tab would be created.
Is there a way using VB where I can get the tabs to be renamed based on whichever managers are in the 'Master Sheet' and then copy and paste the data in to their sheets?
Hope I've explained this clearly enough.
Thanks
