james620
06-03-2010, 02:41 PM
Could anyone please help me sort out this vba code? i've got myself tangled in a web of code!!
I have a spreadsheet attached. It has 3 tabs. Tab 1 is the shifts for drivers. it will simply have a number in it indicating what van they are driving. sheet 2 shows daily who is on what van for quick reference, and then sheet 3 is a list of people who are trained in another driving skill.
Basically, I update the first sheet with the van number, the macro then takes the driver's number (the 4 digit bit in col f, and diplays that next to that date and van number.... if that makes sense?
i have put in a load of 1, 2 and 3's I originally wrote the macro (and it worked) having the quick reference bit at the top, all on 1 sheet... but since re-writing it (and this being my first vba project... i dont think ive done too badly!!!) it seems to have all gone wrong....
Any help to either fix or simply the code would be very much appreciated...
James
:banghead:
I have a spreadsheet attached. It has 3 tabs. Tab 1 is the shifts for drivers. it will simply have a number in it indicating what van they are driving. sheet 2 shows daily who is on what van for quick reference, and then sheet 3 is a list of people who are trained in another driving skill.
Basically, I update the first sheet with the van number, the macro then takes the driver's number (the 4 digit bit in col f, and diplays that next to that date and van number.... if that makes sense?
i have put in a load of 1, 2 and 3's I originally wrote the macro (and it worked) having the quick reference bit at the top, all on 1 sheet... but since re-writing it (and this being my first vba project... i dont think ive done too badly!!!) it seems to have all gone wrong....
Any help to either fix or simply the code would be very much appreciated...
James
:banghead: