Forum Discussion
formulla
Hello, I am Ismail from Iran. My job is accounting and I use the Excel 2016 program and we are in the business of buying agricultural products. We buy the agricultural products of at least 500 garden...
Please don't be so impatient! All participants here are users like you who voluntarily spend some of their free time to help others. That means you cannot demand an immediate reply.
See the small sample workbook that I have attached. It has a summary sheet and three sheets named 1, 2 and 3.
The summary sheet has formulas using the INDIRECT and HYPERLINK functions. The hyperlinks are in column B.
SORRY .But I don't know how to do this for 500 sheets. Because I like to work with Excel, but I'm a beginner in this field and it's a bit difficult for me to speak and translate English.