I need help with simple code

 Blocked Profile -
I need a piece of code that would search B1:N10 in Sheet1 for dates then copy the corresponding A:i value to a column in Sheet2 labeled with that date. ex: in Sheet1 there's a column A1:A10 filled with names. if a date is entered in any row then Sheet2 would get the name in A1:A10 of that row and paste it to a column in Sheet2 labeled with the corresponding date.

Jan 12 Jan 13 Jan 14
Mike Joe Frank
Frank Mike
Mike Joe

1 reply


Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)


Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.