Transfer cell data based on date

[cbrandonsmith]

I am looking to transfer data from one cell to another based on dates. For example, on worksheet 1 having a cell (let's say cell B2) that has today's date (=today function). If today's date equals a date on worksheet 2 (cell D2) then transfer the data from worksheet 1 cell B3 to worksheet 2 cell D3. Worksheet 2 will have all the work days in the month and when the date on worksheet 1 matches a date on worksheet 2, the data is transferred to worksheet 2. Worksheet 1 is just an entry point for employees. Worksheet 2 contains all the data which I will manipulate into percentages. Any ideas?
Thanks!

[stnkynts]

Based upon the information you provided.

Please Login or Register  to view this content.

[cbrandonsmith]

Thank you for your reply. I was not able to make that code work but have attached a sample of what I am trying to do. on worksheet 1 in B3 is the daily input. I am trying to get the value in B3 to be input in the cell underneath the corresponding date on worksheet 2. pace modified.xlsm

[stnkynts]

It didn't work because you didn't supply accurate information. I followed what you stated in your first post exactly.

Here is the amended code based upon the example worksheet supplied in your most recent post.

Please Login or Register  to view this content.

[cbrandonsmith]

That works wonderfully! And you are correct, I did change the worksheet uploaded from what I initially stated. But, and this is on me, I cannot get the code to run automatically. I'm not versed enough in code to get it to run without me using the run command every time a number is entered. Can you assist with this?
Thank You!

[stnkynts]

How would you like the code to be triggered automatically? When you open the workbook, when you change sheets, when you enter data in a cell, etc? Please specify.

[cbrandonsmith]

I was thinking that when the value is entered it would automatically show in the second page of the workbook. So when the value is entered. Thanks!

[sktneer]

For this you will need a sheet change event and to do this, right click on Sheet1 Tab --> View Code and then paste the below code on the code window.

Please Login or Register  to view this content.

[sktneer]

Moreover if you are likely to input the values in B3 of sheet1 only, you may try something like this.....

Please Login or Register  to view this content.

[cbrandonsmith]

Wow, thank you both so much for this. That works as intended. Last question. I am looking to have this same function for 4 input rows (see attached worksheet). I can't seem to modify the code you posted to get it to do that. I am more of a math user with excel and not so much a code person. Any help is greatly appreciated!pace modified 1.xlsm

[stnkynts]

Please Login or Register  to view this content.

[sktneer]

stnkynts has already responded to your request.
Here is the workbook with the code.

[cbrandonsmith]

Thank you gentlemen, I must be doing something wrong as I cannot get the code to work at all.

[stnkynts]

I must be doing something wrong as I cannot get the code to work at all.

Did you enable macros? Using the example sheet sktneer provided type a value into cell B3 on sheet1. It will put it into the corresponding cell on sheet2.