View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
william4444[_2_] william4444[_2_] is offline
external usenet poster
 
Posts: 1
Default 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=4928 |
+-------------------------------------------------------------------+

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