An Illusive Macro

[gelpena]

Hello to all,
I'm just a novice to VBA and have been trying to get a little program to work. I need your help!

Can anyone write a macro for my program that with a button on Sheet2:

- searches area of Sheet1 B1:B500 thru AC1:AC500 for dates (12-Jan, etc). In Column A1:A500 there are 500 names.

- Sheet2 has 365 columns labeled with dates (1-Jan, 2-Jan, etc). The value that's copied to these columns will be the name (Ai) corresponding to the date.

Example: if Sheet1 (B3 = 28-Jan) then column 28-Jan in Sheet2 would be populated with A3 value (name).

 

[jproffer]

http://www.vbaexpress.com/forum/showthread.php?p=259376#post259376

CP

 

[Peter_SSs]

Welcome to the MrExcel board!

Cross-posting (posting the same question in more than one forum) is not against our rules. However, for the future, you might note point 24 of our Guidelines for Posting.

You might understand that some helpers may become disgruntled if they put time into developing a solution here only to find later that a solution had already been achieved elsewhere. They may then be less likely to help you next time.

If you do cross-post in the future but also provide a link, then there shouldn’t be a problem.

 

[gelpena]

I have gotten great help! It's still not 100% but I could not thank enough MD.
http://www.vbaexpress.com/forum/showthread.php?p=259606#post259606

 

[gelpena]

Re: An Illusive Macro [SOLVED]

Thank you to all who looked at my code and provided assistance. Thank you mdmackillop very, very much for the code! Nsenor Udofa provided me
with the last line. Thanks all!!!!

http://www.thecodecage.com/forumz/m...ogramming/212051-stop-values-duplication.html

 

[LucyJ12]

http://www.vbaexpress.com/forum/showthread.php?p=259376#post259376

CP

I was looking for a solution and stumbled across this thread and the above post was a massive help to me so a huge thank you