Please Help Create Sub Sheet w/Master Sheet using VBA/MACRO
Closed
anniesmash
Posts
1
Registration date
Thursday 24 September 2015
Status
Member
Last seen
25 September 2015
-
25 Sep 2015 à 03:46
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 27 Sep 2015 à 14:23
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 27 Sep 2015 à 14:23
Related:
- Masterroyale. net
- Create new sheet vba - Guide
- Little alchemy cheat sheet - Guide
- How to copy data from one excel sheet to another - Guide
- Master royale - Download - Strategy
- Excel hyperlink to another sheet - Guide
1 response
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
27 Sep 2015 à 14:23
27 Sep 2015 à 14:23
You mention 'certain information' but you don't specify what information.
This should replicate the MasterSheet to the SubMaster sheet so changes to the MasterSheet are also put in the SubMaser sheet.
Put this in the VBAProject for MasterSheet.
This relies on the two sheets being copies of each other to start with (it looks like there are).
This should replicate the MasterSheet to the SubMaster sheet so changes to the MasterSheet are also put in the SubMaser sheet.
Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("SubMaster").Range(Target.Address) = Target.Formula
End Sub
Put this in the VBAProject for MasterSheet.
This relies on the two sheets being copies of each other to start with (it looks like there are).
