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
341
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 reply

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