I
L
T
A
W
H
I
T
E
P
A
P
E
R
|
L
I
T
I
G
A
T
I
O
N
A
N
D
P
R
A
C
T
I
C
E
S
U
P
P
O
R
T
28
USING EXCEL MACROS TO CREATE FOLDERS AND SUBFOLDERS
If you were provided with a list of folders and subfolders to be created or if
you have a template you use for your eDiscovery folders, instead of creating
them manually, you can automate the creation using a list in Excel.
The Litigation Support Guru website has an excellent description on
how to do this: https://litigationsupportguru.com/fast-tip-friday-create-
folders-from-list-in-excel as well as how to create subfolders http://
litigationsupportguru.com/fast-tip-friday-create-subfolders-using-excel-
macro
MERGING INFORMATION FROM ONE EXCEL LIST TO ANOTHER
For example, if you have a spreadsheet with the following information:
Sheet 1 "FileNames" contains the list of documents to which the additional
information from Sheet 2 needs to be appended for each row:
Sheet 2, "Coding", is the complete list of documents from A00000001 to
A00000010 and additional information:
The information from List 2 needs to be matched to the same unique value
in List 1 and appended to the row. This can be accomplished using the
VLOOKUP formula:
