hello, i need to search a variable in an existing workbook and then copy the name of the sheet in which it si contained and paste it against the variable name existing in the different workbook.
for example: workbook 1 has variables @,#,$,% in columns B1, C1, D1,E1. now I want to search these variables in another workbook i.e. workbook 2. now say variable @ appears in sheet 1, sheet 4, Sheet 6, Sheet 7, then I want the name of the sheets, i.e. sheet1 , sheet 2, sheet 3, sheet4 to appear in workbook 1 in column B1 containing variable @ below variable @. please help me write the macro for it.
Find variable and paste name of sheet in another workbook