VBA code to move data from a entry sheet to a historical sheet by date

In the attachment you will see an example of what I am trying to accomplish. What I am trying to do is find VBA code that will move data by date from an (Entry) sheet to a (Historical) sheet. I want to enter a date in B3 on the (Entry) sheet. I then enter data into C3. What I would like to happen is when the data is entered into C3 the sheet goes and finds the same date that I entered in B3 and copies that data from C3 into Column E of the (Historical) sheet.


Thank you and any help given is greatly appreciated.

Test3.xlsm

Do you mean to sum the values like this? (Put in Entry sheet)

Please Login or Register  to view this content.

stnkynts,

Thank you for the help. This is sort of what I want it to do. The attachment on the original post is just a small example of what I will be doing. There will be multiple tabs. That is why I want an "Entry" tab. I am trying to avoid going to every single tab to enter data. My plan was to get the code and then just duplicate it for the others to be created. To answer your question... No I don't want it to sum. There should not be data in the date selected on the historical tab. If there is data I would rather it just over write it. To keep things simple for a rookie coder that is why I want the code on the historical sheet. I would prefer to not have message boxes in the code. I have made a format change that will hopefully simplify the coding process. I have put a couple of cells on the historical tab that read back to the entry tab. Attached you will see those changes. Test3.xlsm

Again thank you for all of your help.

So you need to loop through each worksheet and find the corresponding date (Entry Sheet B3) and enter the corresponding value (Entry Sheet C3) to the found date?

Please Login or Register  to view this content.

Stnkynts,

I am very sorry about the confusion. As you can tell I am not very good at this coding stuff. There will be different cells for data on the Entry sheet for each historical sheet. As you will see on the attachment... On the Entry Sheet C3 and D3 will read to the Historical 1 sheet, C4 and D4 will read to the Historical 2 sheet, and C5 and D5 will read to the Historical 3 sheet. I have inserted cells at the top of each Historical page that read back to the Entry sheet. What I would like code for is the cells at the top of each historical sheet to save the data by date on their own sheet. After I posted and got your original reply I thought this would be an easier way to code it. That way I can keep the code specific to each historical sheet.

Thank you for your patients I really appreciate your help.

Test3.xlsm

Your values on the entry sheet column B MUST match the other sheet names exactly, spaces and all!!

Please Login or Register  to view this content.