Excel help, i require good pastelink suggetion?

Question

in excel i have many sheets in my file and first one is INDEX and in index i fill what i want to fill in all other sheets in one perticuler column.

so in the INDEX sheet in first column i will give sheet name and in second column i will give column name and in third column i will give row number and in fourth column i will give some alphanumeric data i want to pastelink that data in that perticuler sheet number, row number and column number written previosly.

what formula will work (if then, goto, pastelink)?

i want preset formula, i don't want to pastelink every time, it should understand and pastelink everytime automatically.

Answer 1

use the HYPERLINK formula. The syntax is =hyperlink([workbookname]sheetname!cellr... name)

For eg. If you want to hyperlink to Sales excel file sheet3 cell A1 then give the formula as

=hyperlink([Sales]Sheet3!A1,"Sales A1")

Hopes this will help