Macro to transfer data from main sheet to sub sheets

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

Joe,

I was looking at your post and workbook, however I was unable to see what your talking about. If you could provide a before and after example.

Joe,

Yes it does thanks. If I do not get back too you on this today, maybe another forum member will also take a look also.

Joe,

Here's what I came up with.
You will see a command button. Make your selection and the click the button.

Joe,

It should not matter if it's from a dropdown the value in B2 will be that of the dropdown selection.
Also what do you mean by you could not get it to work. What happened?
Also I might suggest being you want to see the last entry to the Agent than instead of using the dates as you have then in the worksheet that you would when the button is clicked add the data to the next empty row in the Agents worksheet. This way you will see the last entry.

In this attachment you will see button 6 you can onlt use gimma j for testing. I modifed the agents worksheet.

Joe,

About ready to leave, but when you say you can not get it too work?
Whats not working? Do you get errors?

Joe,

When you click "Button3" it should fire off "Sub Xfer_Data".
What you may try is do a "Right click" the button to see if it's assigned to the above mention sub. If not assign it.

Joe,

If the date find is good then it should populate the data to the correct cells.
I just look at my copy and it works.
Remember I change the worksheet for Gimma J.