Copying cell data from one sheet to another based on date.

this is similar to another just posted, but not quite. I have cells I want copied from one sheet to another based on the date on the first sheet (sheet St. J - DWR cell L6). Cells to copy are Sheet St. J cells C34:G34 (and others). They will be copied to a second sheet called totals, and be copied to the cells under today's date.

Your data are riddled with meged cells and wrong match. Evenif I trim it, 91L does not match with 91 L. I have unmerged cells and have manually corrected the words in sheet Totals.
For the code to work,employee numbers on borh sheet should match.

Thank you. That gets the data copied to the first range on the 'totals' sheet. How do I tweak it to be copied under the correct date on the 'totals' sheet? No matter what date is in the 'St.J DWR' (L6) cell, it only copies to the first place on 'totals', not under the correct date. It looks like the code is trying to find the correct date...

Attach a sample output.

See Attached.

I'm also confused by your comment that employee numbers on both sheets should match, as employee info is only on one sheet.

Try to match column B of St. J DWR with column C of Totals.
What are these numbers?
91 L
91 R
93 L
93 R

91L
91R
93L
93R
VT 5
VT 2E
VT 2B
BSA
COR

If you were not trying to match both these columns, it is a wrong code and just forget the code.

Yes, I'm trying to match those columns. They should be the same on both sheets. They are road numbers in our area, and I want to record data from each day over to the 'totals' sheet.

Are they the same?

Yes, these should be the same on both sheets.

As I said in my first post, 91L is not equal to 91 L
Try it yourself.
I have to use the trim function to remove the space.

It looks like they are the same, with spaces. I removed the spaces and tried again, but the data fills the first area, not under the correct date, on the totals sheet.

I have adjusted the code. The only issue left now is if you want to clear existing data. If you do not want, please remove this line from the code.

Please Login or Register  to view this content.

Thank you. Can I copy some of the code to move the right side of the St. J DWR sheet over to the 'totals' sheet? I'm referring to the data for RT 5, RT 2E, RT 2B, BSA, and COR. ? Or will that need to be added separately?

This requires to completley write the code from a scratch. I will do it in a couple of hours.

Try the attached.
If the two codes do not match the code will not work. COR and COR. ARE NOT THE SAME

I was going say the same! I had this expereince a while back.

Thank you again, VERY MUCH!