hello friends ,
i have two different workbook ..
workbook 1 = formula.xlsx
workbook 2 = hyperlink.xlsx
name of sheets in both workbooks are same
sheet 1 = 5055
sheet 2 = 5560
now , is it possible if i am in cell b3 in worksheet 5055 of formula workbook ,
and when i switch to hyperlink.xlsx , i am in automatically or already in b3 cell of worksheet 5055 of hyperlink workbook.
formula.xlsx is main workbook , where main data is stored and studied
for sample file i have attach two files with smaller data and only two sheets ,
but actual data and number of sheets are more....
Bookmarks