An Illusive Macro

G

gelpena

New Member
Joined
Feb 4, 2012
Messages
3
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!:confused:

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).
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Drrellik
  • Solved
VBA to complete Index/Match with 2 criteria
2
Replies
10
Views
422
Alex Blakenburg
A
Agnarr
  • Question Question
VBA problem with creating new sheets
Replies
0
Views
813
Agnarr
Agnarr
L
  • Question Question
Loop through a table in Excel: when a cell contains a value, copy this value to another sheet
Replies
6
Views
1K
Mario_R
M
D
  • Question Question
Problems Encountered When Generating VBA Excel Charts with 15-Minute Interval Data.
Replies
0
Views
356
dilshod_k
D
J
  • Solved
Calculate last 5 soccer team goals using data from another sheet on same workbook.
2
Replies
19
Views
2K
felixstraube
F

Forum statistics

Threads
1,223,886
Messages
6,175,191
Members
452,616
Latest member
intern444

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top