bleedUTorange
New Member
- Joined
- Aug 3, 2011
- Messages
- 9
I need help to create an Excel 2007 macro for copying two pieces of data from worksheet “A” to worksheet “B” based on a specific date.
On Worksheet “A”, there are 4 pieces of data; Employee name (column A), Decisions (column B), Touches (column C) and lastly Date (column D).
On Worksheet “B” I have the date in ascending order in column A (i.e. A1 = 10/01/11, A2 = 10/02/11, continues through the end of the month). I also have Decisions (column B) and Touches (column C).
I need a macro that will identify the date in Worksheet “A” (column D), copy the values under Decision and Touches (column B and C respectively) of worksheet "A" and then paste it in Worksheet “B” to the corresponding date under the corresponding headings (Decision and Touches).
Thank you for your time in advance. Your help will be greatly appreciated.
On Worksheet “A”, there are 4 pieces of data; Employee name (column A), Decisions (column B), Touches (column C) and lastly Date (column D).
On Worksheet “B” I have the date in ascending order in column A (i.e. A1 = 10/01/11, A2 = 10/02/11, continues through the end of the month). I also have Decisions (column B) and Touches (column C).
I need a macro that will identify the date in Worksheet “A” (column D), copy the values under Decision and Touches (column B and C respectively) of worksheet "A" and then paste it in Worksheet “B” to the corresponding date under the corresponding headings (Decision and Touches).
Thank you for your time in advance. Your help will be greatly appreciated.
