Hello, Consider my Thread Cherry popped! 
I'm relatively new to the whole VB thing but seem to have picked it up quite quick by using Record and reading these forums & manuals and generally messing with it until it does what I want it to, but I can't seem to find what I'm looking for now.
Basically, I have 2 Workbooks - One has lots of info about all staff/contracts etc that most staff don't need to see (WB1), the other is specifically for staff to use on a daily basis (WB2) - there will be one of these per staff member.
I need a process to copy a single sheet from WB1 IF the name of the sheet = the name of WB2 (or the same as a Cell within WB2)
I know there is probably an easier way to setup a single macro for each one, but I have around 300 of these to do - so one code for all would be much easier.
Any help would be much appreciated.
Cheers,
Vistaz86
I'm relatively new to the whole VB thing but seem to have picked it up quite quick by using Record and reading these forums & manuals and generally messing with it until it does what I want it to, but I can't seem to find what I'm looking for now.
Basically, I have 2 Workbooks - One has lots of info about all staff/contracts etc that most staff don't need to see (WB1), the other is specifically for staff to use on a daily basis (WB2) - there will be one of these per staff member.
I need a process to copy a single sheet from WB1 IF the name of the sheet = the name of WB2 (or the same as a Cell within WB2)
I know there is probably an easier way to setup a single macro for each one, but I have around 300 of these to do - so one code for all would be much easier.
Any help would be much appreciated.
Cheers,
Vistaz86
