Need Help writing a macro

[ahovancsak]

I do not really know where to begin with this macro. I need the macro to basically take column A (the date from there) from one sheet match it with A (date from there) and paste Column A, B, C to columns I,K,K on the main sheet.

Sheet A

Column A Column B Column C
2/1/15 15:26 Door 1
2/2/15 18:30 Door 2
2/3/15 4:01 Door 3

Sheet 2

Column A Column B Column C Column I J K
2/1/15 15:26 Where sheet 1 column A B C would go after the two column A are matched by the date.
2/2/15 18:30
2/3/15 4:01

[scottiex]

Every thread here "needs help writing a macro" - your title should be descriptive of what you actually need.
Please edit it to conform with the forum rules.

Also you should provide a sheet with sample starting data and the result you require

refer to this post on your previous thread

http://www.excelforum.com/excel-prog...ml#post4189327

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )