Hi,
Can someone help me please, i'm trying to copy data vertically on one worksheet from another where the data is generated horizontally. I've researched it but apparently i'm not very good at research because I can't figure it out on my own. Example, would be on wkshtA cell a4 needs data from wkshtb cell k2 then wkshtA a5 needs wkshtb k3, then a6 needs k4 etc etc etc. I'm sure its simple and i'm missing it, but just the same I can't figure it out.
If you are just copy/pasting, try copy/paste tranpose
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
not copying and pasting, i'm wanting to lock these cells eventually so they pull the data from the other worksheets automatically once I have them set. I could go through and do them all manually but there are multiple lines all drawing data the same way so trying to do it so it pulls it automatically. tried using a vlookup, hlookup, index, and indirect functions but none of them seem to do what I want. Each cell is only looking to copy data from another cell on a different wksht. Does this help any.
Your explanation doesn't match your subject line.
A4 = K2
A5 = K3
A6 = K4
Those are both vertical ranges.
If you want to do this:
A4 = K2
A5 = L2
A6 = M2
Entered in A4 and copied down:
=INDEX(K$2:M$2,ROWS(A$4:A4))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Yep, your right I did screw that up, let me try it again. I am trying to capture data from a different worksheet for example:
wkshta wkshtb
a4 a4
b4 a5
c4 a6
d4 a7
e4 88
thats what its supposed to be, thanks for figuring out what I was trying to do. I'm trying the index suggested.
Ok...
Assuming you want the formulas on wkshta.
Entered on wkshta in cell A4 and copied across:
=INDEX(wkshtb!$A4:$A8,COLUMNS($A4:A4))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks