Copy/Paste row based on Date

Closed
Shawn - 12 Jan 2017 à 14:57
Shawn0 Posts 1 Registration date Tuesday 17 January 2017 Status Member Last seen 24 March 2017 - 17 Jan 2017 à 14:32
Greetings,
I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the data I want to copy never contain the same amount of rows with the same date so I need a solution beyond VLOOKUP and INDEX. I am a complete NOOB as far as VB scripting but do know the editor in Excel and familiar with Macros. Below is an data example and any help would be appreciated.

Sheet 1
1-Jan
Paste row

2-Jan
Paste row

3-Jan
Paste row

4-Jan
Paste row

Sheet 2
XXXX XXXXX XXXX 1/1/2017 XXXX XXXX XXXX
XXXX XXXXX XXXX 1/1/2017 XXXX XXXX XXXX
XXXX XXXXX XXXX 1/3/2017 XXXX XXXX XXXX
XXXX XXXXX XXXX 1/4/2017 XXXX XXXX XXXX
XXXX XXXXX XXXX 1/4/2017 XXXX XXXX XXXX
XXXX XXXXX XXXX 1/4/2017 XXXX XXXX XXXX

1 response

Shawn0 Posts 1 Registration date Tuesday 17 January 2017 Status Member Last seen 24 March 2017
17 Jan 2017 à 14:32
I have since created an account. Any help would be appreciated.