Hi All,
I have an Excel Spreedsheet & within this there are Two sheets. 1) Summary & 2) Original Data. What i would like to create is a Macro Button that will be on the Summary Sheet & once i press this it will bring Data from Sheet Original Data only the Business Centre Name highlighted in Yellow & only the Sick Highlighted in green & the FTE Figure which is in Coloumn B. Would appreciate all the help. Attached is an example sheet on what the data looks like.
Cheers
Will
Bookmarks