# Drag horizontally and copy vertical cells

1. ## Drag horizontally and copy vertical cells

Hello
i am newbie to excel and i need some help in this issue
i have copied A1 cell from sheet 1 into A1 cell from sheet 2
what i need to do is to drag A1 of sheet 2 horizontally (B1, C1, D1) and get the vertical values (rows) of sheet 1: A2, A3, A4, etc...

Is it possible
because i would to deal with sheet 1 only and get the results on sheet 2 automatically

2. ## Re: Drag horizontally and copy vertical cells

Dp you need the SUM, or just the values?

3. ## Re: Drag horizontally and copy vertical cells

If you just need value then paste this is A1 of sheet 2 and drag it acrossed. It will grab any values in the corresponding cell on sheet 1
``Please Login or Register  to view this content.``

4. ## Re: Drag horizontally and copy vertical cells

Just the values

5. ## Re: Drag horizontally and copy vertical cells

Okay the formula I posted will copy the values of A1 in sheet 1 to A1 in sheet 2. Dragging it to B1 does B1 sheet1 to B1 sheet2 etc.

6. ## Re: Drag horizontally and copy vertical cells

You can do this with INDEX and COLUMNS
IF your data is in sheet1 A1:A1000 and your formula is in A1 of Sheet2

=INDEX(Sheet1!\$A\$1:\$A\$1000, COLUMNS(\$A\$1:A1))
Does that work for you?

7. ## Re: Drag horizontally and copy vertical cells

I guess it helps if I pay attention to the fact he wanted Vertical values. Disregard shamskh2. That just gives horizontal values.

8. ## Re: Drag horizontally and copy vertical cells

I am out of office now...will try it and tell u how it worked
Thanks

9. ## Re: Drag horizontally and copy vertical cells

@chemist B
it worked very well.
Thank you very much

10. ## Re: Drag horizontally and copy vertical cells

Do you know if i can use the same formula but to skip one cell constantly
i mean when the row are copied i want to see in sheet 2
A1, A3, A5...etc and not A1, A2, A3, A4, A5
without leaving blank cell or a 0 instead.

11. ## Re: Drag horizontally and copy vertical cells

May be this.....

``Please Login or Register  to view this content.``

12. ## Re: Drag horizontally and copy vertical cells

=INDEX(Sheet1!\$A\$1:\$A\$1000, COLUMNS(\$A\$1:A1)*2-1) for 1,3,5,...

=INDEX(Sheet1!\$A\$1:\$A\$1000, COLUMNS(\$A\$1:A1)*2) for 2,4,6,8.......

13. ## Re: Drag horizontally and copy vertical cells

Thank you a lot
both worked very well

14. ## Re: Drag horizontally and copy vertical cells

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -

Incase your issue is not solved, you can undo it as follows -

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

15. ## Re: Drag horizontally and copy vertical cells

ChemistB,
I have tried this and it does not work for me.
My data is in sheet1 Cell S77.
I typed the following formula into Cell F4 of Sheet 2

INDEX('sheet1'!\$F\$4:\$S\$77, COLUMNS(\$F\$4:F4))

Thanks

16. ## Re: Drag horizontally and copy vertical cells

You can copy the url for this post and include it if you think this post is relevant.

17. ## Re: Drag horizontally and copy vertical cells

Thank you Sambo kid for your help.
I just registered yesterday afternoon and am not well versed on the how to's.
I was just looking for assistance.

18. ## Re: Drag horizontally and copy vertical cells

How do I start a post.
I have searched your site and I believe I have not been afforded this ability.

19. ## Re: Drag horizontally and copy vertical cells

At the top is a blue post a thread button in each forum, just click that.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1