I need help with simple codeClosed

Question

Hello, 
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
Configuration: Windows Vista / Internet Explorer 9.0

pcsces · Answer

Greetings,

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.)

https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator

I need help with simple code

1 response

Similar discussions

Subscribe To Our Newsletter!