Previous Topic Next Topic

Possible to copy/paste row based on dates?

Closed
Shawn0 Posts 2 Registration date Tuesday January 17, 2017 Status Member Last seen March 24, 2017 - Mar 24, 2017 at 08:45 AM
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
Paste row

2-Jan

3-Jan
Paste row

4-Jan
Paste row
Paste row
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