Hi
I need some help with the attached workbook.
I have macros on another sheet and workbook which puts the data in B12:15.
Depending on the date b1 and the person specified b2, i want the data to then transfer over to the other sheets on the workbook.
ie if gemma J did 25 pnc on 23-11-10, then i want it to take this over to the sheet gemma j and find the pnc box and input the figure for that date, in this case, b24.
I then want whenever the next person clicks on a particular persons tab, that it immediately shows the last piece of data entered.
I think this is quite easily possible, but am having problems with it. So if anybody could help i would be very appreciative.
Kind regards
Joe
Bookmarks