@ravikumar_bavigadda Hi Ravi, You can always expect a reply from the community. It can be late but never ignored.
Well, first of all I would need some clarification regarding your question. For now, it more looks like you want help with hyperlinks in excel rather than R.
Here are few things that I am assuming.
1- You have exported your data frames into three worksheets within the same workbook.
2- You want to navigate to the last two sheets using the entries in the first sheet.
If all my assumptions are correct, then below is the method you can use to place the hyperlinks:
1- Select the cell where you want to place the observation “sales”.
2- Right click on the cell and choose “hyperlink”.
3-The Insert Hyperlink dialog window appears on the screen.
Choose Place in This Document in the Link to section if your task is to link the cell to a specific location in the same workbook.
Select the worksheet that you want to link to in the Or select a place in this document field.
Enter the cell address in the Type the cell reference box if you want to link to a certain cell of another worksheet.
Enter a value or name into the Text to display box to represent the hyperlink in the cell.
The cell content becomes underlined and highlighted in blue. It means that the cell contains the hyperlink. To check if the link works, just hover the pointer over the underlined text and click on it to go to the specified location.
Repeat with the other observation.
Please let me know, if you wanted something else.