ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
The Manual / The Instruction Sheet
2
3
So, in the menu, under Extensions is a menu item called Apps Script.
4
This spreadsheet uses one, look for the Menu Item labeled "Migrate Data"
5
That was made by the script attached to this spreadsheet.
6
7
! So, import the sheet of updated data, at any time and it becomes a new sheet with it's own
8
name n stuff at the bottom.
9
10
You go to that sheet and select the first cell of the column where you want to start.
11
choose "Create New Sheet" from "Migrate Data" and the script will:
12
-Create a copy of Template, so you get a preview of the header.
13
-Split the song from the artist based on the character "-"
14
-Stop working if something odd came up.
15
! You can find and then select the next valid cell and then run the script again
16
to resume from after where it last failed
17
! Fix that awkward weird titled song yourself.
18
! glue the next new sheet to the first after it's all done.
19
! Export that fancy new sheet, and save it over your old one.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100