I have arrays with preexisting data called EDD, WSPT, and SPT
calculated earlier in the program. I would like the user to enter one
of these array names into the worksheet. I then want my program to
read in the array name but then somehow make that correspond to the
matching array with the existing data.
for example
ArrayName=Worksheets("Master").Range("B6").Offset( MasterOffset, 0)
Gives me "EDD"
I then want to output the EDD array:
Worksheets("Hidden").Range("A1").Resize(N_Jobs, 8).Value = ArrayName

How do i accomplish this?