Hi there
I dont know if i will be able to explain this but here I go.
I am trying to to a sumif to get the result in a different sheet the first thing i need to do is to find sheetnames from workbook then once the workbookname is fund then set the range and the usual,
here I try to explian again in
Where (workbook(sheetname)=A1,sumif(workbook!sheetA1!A1:A30,D1,Workbook!sheetA1!D1:D30)
and i need this to work for to workbook is it possiable.
thanks
I hope i have explained it .
I dont know if i will be able to explain this but here I go.
I am trying to to a sumif to get the result in a different sheet the first thing i need to do is to find sheetnames from workbook then once the workbookname is fund then set the range and the usual,
here I try to explian again in
Where (workbook(sheetname)=A1,sumif(workbook!sheetA1!A1:A30,D1,Workbook!sheetA1!D1:D30)
and i need this to work for to workbook is it possiable.
thanks
I hope i have explained it .