if i have in sheet1 dd59:1 de59:2 df59:3
how to make in sheet2: f3:1
f4:2
f5:3
vertically. i want it to be continuous by dragging. plz it would help alot.
if i have in sheet1 dd59:1 de59:2 df59:3
how to make in sheet2: f3:1
f4:2
f5:3
vertically. i want it to be continuous by dragging. plz it would help alot.
Try this...
=INDEX(DD$59:DF$59,ROWS(F$3:F3))
Copy down
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
i put it like this =INDEX(sheet1!DD$59:DF$59,ROWS(sheet2F$3:F3)) in f3 of sheet2 but coming wrong. whats my mistake here?
=INDEX(sheet1!DD$59:DF$59,ROWS(sheet2F$3:F3))
You had sheet2F$3.... it should have been sheet2!F$3 to be corret. however, you don't actually need the sheet - as it's just a couter; so ROWS(F$3:F3)) works perfectly. Final formula:
=INDEX(Sheet1!DD$59:DF$59,ROWS(F$3:F3))
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
You don't have a ! in the Sheet2 name. However, you don't need the sheet2 name in this case.
=INDEX(Sheet1!DD$59:DF$59,ROWS(F$3:F3))
Here's a sample file to demonstrate this...
thank u guys i found it. i really appreciate it. keep up the gr8 work!
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks