Previous Topic Next Topic

Copy/Paste row based on Date

Closed
Shawn - Jan 12, 2017 at 02:57 PM
Shawn0 Posts 2 Registration date Tuesday January 17, 2017 Status Member Last seen March 24, 2017 - Jan 17, 2017 at 02:32 PM
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 reply

Answer 1 / 1
Shawn0 Posts 2 Registration date Tuesday January 17, 2017 Status Member Last seen March 24, 2017
Jan 17, 2017 at 02:32 PM
I have since created an account. Any help would be appreciated.
0