VBA Excel Format (Based on Date and Criteria)

[unknownymous]

Hello Gurus,

Trust you are doing well at this times.

I just wanted to get your thoughts on how to code this.

I have a workbook with two sheets:

Sheet 1

Date	Account	Reference
12/30/2018	5000	0001
11/30/2018	4000	0001
10/30/2018	3000	0003
09/30/2018	4000	0002
08/30/2018	3000	0005
07/30/2018	2000

Sheet 2

Book	Name	Note	12/30/2018	11/30/2018	10/30/2018	09/30/2018	08/30/2018	07/30/2018
1111	Selena		100	95	90	85	80	75
2222	Mike	x	95	90	85	80	75	70
3333	Taylor		85	80	75	70	65	60
4444	Sean		80	75	70	65	60	55
5555	Connor	x	70	65	60	55	50	55
6666	Beth		75	70	65	60	55	50
7777	Tom		70	65	60	55	50	45
8888	Gerry		65	60	55	50	45	40

I was looking if there's a code for me that I can run so I can have this result: OUTPUT (format)

1. Basically, I need the data in descending date and shares format.
- Data columns from Sheet 1 are the Date , Account and Ref while Book and Number (came from Date Column) from Sheet 2.
- The Dates in Sheet 1 could be long but there will always be a corresponding data based on headers in Sheet 2.
- The macro will copy until the last non blank cell in Sheet 2

Date	Account	Ref	Book	Number
12/30/2018	5000	0001	1111	100
12/30/2018	5000	0001	2222	95
12/30/2018	5000	0001	3333	90
12/30/2018	5000	0001	4444	85
12/30/2018	5000	0001	5555	80
12/30/2018	4000	0001	6666	75
11/30/2018	4000	0001	7777	70
11/30/2018	4000	0001	8888	65
11/30/2018	4000	0001	1111	95

11/30/2018	4000	0001	2222	90
11/30/2018	4000	0001	3333	85
11/30/2018	4000	0001	4444	80
11/30/2018	4000	0001	5555	75
11/30/2018	4000	0001	6666	70
...and so on

I always have render much time on this task so any help will be much appreciated.

Thank you in advance