Creating a Macro Button to Extract Data

[william4444]

Hi All,
Okay Please refer to the attachment as it illustrates it best. I have
an Excel Spreadsheet with 3 Sheets Inside this. 1) Summary Sheet is
what i would like all the data to go to once i press the Macro Button.
I'd like it to Capture all the Data from Sheets:
2) Sheet 1
3) Shhet 2
Please refer to att: as this best illustrates it in depth.

Thanks
W


+-------------------------------------------------------------------+
|Filename: Send this Copy Book23.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4968 |
+-------------------------------------------------------------------+

 

[robert111]

can you put the info from sheets 1 and 2 onto one sheet only, by
putting jacks shop, freds shop etc in column A, putting facs flex study
etc in col B and reserving columns C onwards for april may june etc
data???

shop type april may
jacks shop facs 33 44
jacksshop study 7 6


if so you could have a sumproduct summary sheet on another sheet that
would update in real time.