Hi,
I'm making a database but having trouble with what should be a fairly simple dragging down.
In Sheet 2, I want cells A2:A120 to read (='Sheet 1'!A1).
I then want cells A121:A239 to read (='Sheet 1'!A2).
and A240:A358 to read (='Sheet 1'!A3).
and so on...
Any help?
Try this out:
=OFFSET(Sheet1!$A$1,INT((ROWS($1:1)-1)/120),,,)
Last edited by Glenn Kennedy; 05-13-2015 at 04:43 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Excellent, Thank you!!!!!!
Thanks for the Reputation that you have added. It's much appreciated. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks