J
J.W. Aldridge
Private Sub Workbook_NewSheet
Need each sheet name to have same prefix then end with cell value.
Prefix: "Jeremy "
Suffix: Value in cell e2: 6/23/2009
For end result, subtract one from date given in e2.
End Result: Jeremy Mon 6-22
Need each sheet name to have same prefix then end with cell value.
Prefix: "Jeremy "
Suffix: Value in cell e2: 6/23/2009
For end result, subtract one from date given in e2.
End Result: Jeremy Mon 6-22