Creating a Macro Button to Extract Data
 

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


+-------------------------------------------------------------------+
|Filename: Book23.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4922 |
+-------------------------------------------------------------------+

--
william4444
------------------------------------------------------------------------
william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991
View this thread: http://www.excelforum.com/showthread...hreadid=554381