I need a data transfer macro

[Kevin.W]

I am trying to make a simple spreadsheet for some people I work with to use each day. I have set up a Data Entry sheet where an individual can input the necessary data.

On the next sheet (tab) I have a simple table where that input data is used to do some calculations, etc and gives the desired results. So, what I need is a simple macro that will lookup the date input on one sheet, search a column of dates on the other sheet, then copy and paste all of the data from the table on into that row.

This doesn't seem to be that difficult in theory but I'm very inexperienced with VBA and I can't find anything out there that does something like this. Please help

 

[Kevin.W]

Never mind! My mistake I did another look over that code and I had missed one small change.

It works perfectly! I'm in awe. Thank you so much for the help Lenze.

 

[lenze]

Post your EXACT code, because mine works fine!!
I used a button from the Forms ToolBar, but it shouldn't matter!

lenze
EDIT: IGNORE
EDIT2:
You might wish to turn off ScreenUpdating to avoid all the flickering!!