Hey guys, just like the title says, basically on Sheet1 cell A1, i want to ='Sheet2'!A1. Be able to drag Cell A1 on sheet1 down the entire A column but copy all the data from Sheet2 going down the row (A1,B1,C1,D1...)
Hey guys, just like the title says, basically on Sheet1 cell A1, i want to ='Sheet2'!A1. Be able to drag Cell A1 on sheet1 down the entire A column but copy all the data from Sheet2 going down the row (A1,B1,C1,D1...)
Put this formula in A1 of Sheet1:
=INDEX(Sheet2!$1:$1,ROWS($1:1))
then copy down as far as you need to.
Hope this helps.
Pete
not working for me Pete. Still only copies Horizontal (row) and not column
Your first post is a bit confusing, as you said "... but copy all the data from Sheet2 going down the row (A1,B1,C1,D1...) ..."
This implies that the data is arranged across the top row (row 1) of Sheet2 (although I don't know why you said "... DOWN the row ..."), and this is what my formula does if you drag it down column A of Sheet1.
Please explain your requirements more clearly, or, better still, attach a sample workbook and show in there what you want to achieve. Here's how to:
Click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Please note that the Paperclip icon does not work.
Hope this helps.
Pete
Nvm got it to work thanks pete
Glad to hear it.
If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.
Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks