I have a very simple formula in an Excel sheet. But the problem is, I need to copy it 50 times while changing the reference cells.
My formula is this:
Formula:
Please Login or Register to view this content.
I would like to expand it until H53 as:
Formula:Please Login or Register to view this content.
I can copy and paste it 50 times and edit the formula. But it will take a lot of time and effort.
Is there any easy way to do this?
Last edited by ajeshkdy; 08-10-2019 at 10:29 AM.
I think you need to tell us more about the context. Explain what the purpose of the formula is. There is no doubt a more effective way of working.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi,
Thanks for your reply.
I have attached a sample file to better understand my situation. In the original file, I have 50 sheets. Each sheet named 1, 2,3 etc has 4000 rows and 5 columns. With the above formula, I am trying to change the random number in F12 of the last sheet according to some conditions as indicated in the formula.
Where in the attachment will we find the cells where you want the formula?
Oh, sorry! My formula is in F12 of the worksheet named 'Key Form' .
Not sure, but try this:
=IF(INDEX($I$3:$I$29,MATCH(ABSTRACT!D5,$H$3:$H$29,1))=F7,INDEX($J$3:$J$29,MATCH(ABSTRACT!D5,$H$3:$H$29,1),""))
I hope this will work after some tweaks.
The values in column H may not be matched with the value in D5 of "Abstract" because Column H contains maximum limit to assign the corresponding random number.
Last edited by ajeshkdy; 08-10-2019 at 11:03 AM.
Yes, well I don't follow that last statement, I'm afraid, but if you can get it working that's good. Let us know.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks