hi all! =)

i'm creating a coaching tracker for my manager which serves as a data base for all the action plans she has for her coaching sessions.
there are about 21 sheets, one sheet for each supervisor and 3 spare worksheets for the template where she inputs the data, another sheet for the settings where she can modify some parts of the workbook(initiates upon workbook opening), and a third worksheet where all the data entered is tabulated by column so this can be turned to a pivot table for easy viewing.

there are 18 supervisors, and i named each sheet by a name that can be sequenced; aTL1, aTL2, aTL3, aTL4... so on until aTL18... the supervisor's name with the corresponding sheet that they belong is tabulated on the sheet 2 (template_settings)...

my problem is about the worksheet object, i'm using a looping statement so excel will find the entered supervisor name on sheet1 (called template) the sheetname it has listed on sheet2 - (template_settings)

on template settings - sheet 2, it looks like this:


a b c d e
supervisor worksheet
1 mark aTL1
2 john aTL2
3 tony aTL3
4 maraiah aTL4
5 kate aTL5
6 don aTL6
7
8

the code :


dim x as integer
x = 1
do until template.cells(1,1) = template_settings(x,1) or x = 7

x = x+1
loop

thisworkbook.sheets(template_settings(x,2)).cells(2,1)submitted
'the code above keeps getting an error "type mismatch"
i'm trying to use a string as an index found by (from the loop statement)
template_settings(x,2)
to return a string value as the sheet index...


for security purposes, i cannot post here the workbook, and the pc i'm using right now doesnt support excel, i'm doing it on another pc...

need help