I currently have the following formula =IF(ISNUMBER(SEARCH("(",$O27)),VLOOKUP(LEFT($O27,4),'Tues Crews'!$B$6:$F$19,2,FALSE),VLOOKUP(Tues!$O27,'Tues Crews'!$B$6:$F$19,2,FALSE)) which i want to insert into a range using a VBA as part of a current macro the problem I am having is I want to use a reference for the tues crews sheet,
so would look something like this.
when I run the macro the sheet I am on becomes Home
=IF(ISNUMBER(SEARCH("(",$O27)),VLOOKUP(LEFT($O27,4),'Home " & Crews"'!$B$6:$F$19,2,FALSE),VLOOKUP(Tues!$O27,'Home " & Crews"'!$B$6:$F$19,2,FALSE))
the reason I want this is that I have a sheet for every day of the week and have slim lined the macro as much as my knowledge allows
any help will be much appreciated
so would look something like this.
when I run the macro the sheet I am on becomes Home
=IF(ISNUMBER(SEARCH("(",$O27)),VLOOKUP(LEFT($O27,4),'Home " & Crews"'!$B$6:$F$19,2,FALSE),VLOOKUP(Tues!$O27,'Home " & Crews"'!$B$6:$F$19,2,FALSE))
the reason I want this is that I have a sheet for every day of the week and have slim lined the macro as much as my knowledge allows
any help will be much appreciated