mykal66
08-14-2014, 10:09 PM
Hey folks - I've spent hours trying to figure out how to fix the issue i am having with a VLOOKUP and just hitting a brick wall
I have adapted a calendar i found elsewhere for use a forward planner for work. My manager then asked if i could filter the events by either department or event type which i thought would be easy using VLOOKUP.
Users enter details on the Schedule Tab and then a VLOOKUP is meant to copy anything for a particular event to a corresponding TAB e.g. all external meetings for any department would be copied to the external meetings tab. This works as long as there is only 1 type of event on the schedule but if there are several types of events (attached workbook) entries are duplicated.
The attached workbook demonstrates the problem i am having. In the schedule for August 2014 there are 6 entries (2 external meetings and 4 reminders) so what should happen is that the External Meeting Tab should only have 2 entries but it has 6 with the bottom one being duplicated up to the point of the first external meeting. The Reminder Tab also does the same in duplicating an actual entry so each tab shows 6 entries inc duplicates.
In the end a macro will just show / hide whichever tab the user wants to see which i have got working - I will carry on working on it today but any advice / help would be really appreciated.
Thank you as always
Mykal12106
I have adapted a calendar i found elsewhere for use a forward planner for work. My manager then asked if i could filter the events by either department or event type which i thought would be easy using VLOOKUP.
Users enter details on the Schedule Tab and then a VLOOKUP is meant to copy anything for a particular event to a corresponding TAB e.g. all external meetings for any department would be copied to the external meetings tab. This works as long as there is only 1 type of event on the schedule but if there are several types of events (attached workbook) entries are duplicated.
The attached workbook demonstrates the problem i am having. In the schedule for August 2014 there are 6 entries (2 external meetings and 4 reminders) so what should happen is that the External Meeting Tab should only have 2 entries but it has 6 with the bottom one being duplicated up to the point of the first external meeting. The Reminder Tab also does the same in duplicating an actual entry so each tab shows 6 entries inc duplicates.
In the end a macro will just show / hide whichever tab the user wants to see which i have got working - I will carry on working on it today but any advice / help would be really appreciated.
Thank you as always
Mykal12106