Copy Data from One sheet in a workbook to another Sheet [Closed]

Report
Posts
1
Registration date
Thursday May 7, 2015
Status
Member
Last seen
May 7, 2015
-
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
-
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

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
66

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!