Hi,
I have a workbook with three worksheets i.e. ‘Summary’, ‘Achievements Data’ and ‘Overdue Data’.
What I require are formulas (vlookup?) on the ‘Summary’ tab which automatically pulls through the filtered data from the Achievements Data’ and ‘Overdue Data’ tabs regardless of what columns I have filtered on (and for whatever criteria) and enters this data in the ‘Achievements’ and Milestones sections on the Summary’ tab
I have attached ‘the Example Data.xlsx’ file and filtered on random data for this exercise on the ‘Achievements Data’ and ‘Overdue Data’ tabs and manually entered it into the ‘Achievements’ and Milestones section on the Summary’ tab as an example
Any assistance in this matter would be greatly appreciated
Regards
Bob
N.B. Excel version 2010
Bookmarks