Copy Data from One sheet in a workbook to another Sheet

Closed
Loren@Tsep Posts 1 Registration date Thursday May 7, 2015 Status Member Last seen May 7, 2015 - May 7, 2015 at 11:45 AM
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - May 7, 2015 at 12:47 PM
Hi,

I'm trying to copy one sheet automatically in one workbook to multiple workbooks. For example the workbook is May 2015 Sales Numbers and the Sheet is Casey. I need all data on that sheet to copy automatically as it is updated to workbook Casey's Team 2015 onto the sheet Casey. Or I have a similar problem getting Workbook Jenna Ford's RGA, Sheet 1 to copy automatically into Workbook Casey's Team 2015, sheet Jenna RGA. I'm figuring that once you help me with one formula I will be able to duplicate it since the situations are always the same. I'm fairly new to the VBA copying of data. I assume I just choose to open the visual basic screen and then copy and paste the formula in there. Thank you so much for your help!

1 response

MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
May 7, 2015 at 12:47 PM
0