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.
Select A2:A3.
Then drag the fill handle down to A501. You will now have the numbers 1 to 500 without having to type them yourself.
Next, select B2:C2.
Then drag the fill handle down to row 501. This will copy the formulas in columns B and C.
- I'm sorry, but unfortunately I couldn't implement your order. There is a possibility of more guidance or doing this work for you. If you do a small favor, do it or explain more, I will be grateful, my friend. Do something friendly, my brother, I will compensate you.