Hi there!
I would be grateful if someone could help me with the following problem.
In B4 I have =Diary!B3
In B5 I have=Diary!B53
How can I drage down and autofill the B column so that B6 will show Diary!B103, etc.
Many thanks in advance for your help.
Last edited by marcimarc; 12-14-2013 at 10:28 AM. Reason: Solved
Try this:
Formula:
Please Login or Register to view this content.
from B5 and drag down.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Or
=INDEX(Diary!B:B,(ROW($A1)-1)*50+3)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks Sixthsense. That works! I really appreciate it!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Here's another one...
Entered in B4 and copied down as needed:
=OFFSET(Dairy!B$3,ROWS(B$4:B4)*50-50,0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks