Hi All,
How to Create a Macro that automatically copies the cells in this range, when typing. To different selected sheets within the workbook.
The Range:-
B9:B1529
C9:C1529
D9:D1529
Into theses Named sheets “Volunteer Info”, “Communications”, Volunteer Spoken Languages”, “EOPS Monitors”
And to create a Macro that automatically copies the cells within the above range based on 3 criteria. In Column B “ID Region” it as a drop down box for each cell “GIR”,”LHS”,”LHW”
Range B9:B1529
If “GIR” is selected, then Copy all cells into Sheet “GIR London Roles”
If “LHS” is selected, then copy all cells into Sheet “Lighthouse South Roles”
If “LHW” is selected, then copy all cells into Sheet “Lighthouse West Roles”
I want a Macro that does all that but I don’t know how to do it, can anybody help me please. <!-- / message --><!-- attachments -->
The Range:-
B9:B1529
C9:C1529
D9:D1529
Into theses Named sheets “Volunteer Info”, “Communications”, Volunteer Spoken Languages”, “EOPS Monitors”
And to create a Macro that automatically copies the cells within the above range based on 3 criteria. In Column B “ID Region” it as a drop down box for each cell “GIR”,”LHS”,”LHW”
Range B9:B1529
If “GIR” is selected, then Copy all cells into Sheet “GIR London Roles”
If “LHS” is selected, then copy all cells into Sheet “Lighthouse South Roles”
If “LHW” is selected, then copy all cells into Sheet “Lighthouse West Roles”
I want a Macro that does all that but I don’t know how to do it, can anybody help me please. <!-- / message --><!-- attachments -->
