- Joined
- Jun 19, 2009
- Messages
- 1
- Reaction score
- 0
Hi
Im a bit of a novice at this but im using a form in excel to add information to 2 worksheets via macro modules. i need to add a macro/module to ensure that any changes to the "Main" worksheet automatically updates 1 of 3 additional worksheets based on specific criteria i.e. if column S specifies Jack update worksheet 2.
Can anyone help?
Thanks
Rach
Im a bit of a novice at this but im using a form in excel to add information to 2 worksheets via macro modules. i need to add a macro/module to ensure that any changes to the "Main" worksheet automatically updates 1 of 3 additional worksheets based on specific criteria i.e. if column S specifies Jack update worksheet 2.
Can anyone help?
Thanks
Rach