copy to next empty cell of active cell

[kingcashandcarry]

one more code that puzzled me
i have a code that select a cell in a range of columns a until e
in that range there are different dates and my code find and select today date
that can be in different column a, c, or e and i have data that is needed to be paste to next empty cell of that date
for example 27 jan 2018 but my code paste data to 31 jan 2018 that is the last empty cell
any help?

 

[vletm]

kingcashandcarry
Have You tried to run that step-by-step and see what will it do?
Do You find both 'coordinates' or what?
I would do that ... another way (of course).

 

[kingcashandcarry]

it was a nice try and i will work your code but in first use i see that brings only one result copied. i made another approach and wrote a code that select range from date until next date -1 and paste values to last cell of that range and then sort with headers . the strange is that wome times works just perfect and other stop working or works with mistakes. i upload the sample

 

[vletm]

kingcashandcarry
Where has written in Your writings
that there would happen more that one copy?
If You could write exact
what would You like to get ...
it would be possible to do ... otherwise not!

Try to figure You case ...
1) how would You do it manually
2) do it step by step

 

[kingcashandcarry]

Sorry for my mistake
yes the range below the date will be filled as many times as in the same date finds results. and i need the range G1:H1 that i want to be copied and paste but i think it's not a problem i can fix by my needs as long as the code works perfectly

 

[kingcashandcarry]

for the story i have found the code and my macro works just perfect with some tricks
thanks