I have two worksheets. I need in 'worksheet 1' to copy b1, c1, d1, to f2, f3, f4 in 'worksheet 2.' However, it must repeat the process so that b2, c2, d2 in worksheet one copied to f5, f6, f7. Anyway do to this or set things up differently so it works?
Thanks
What are you trying to accomplish?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Copy cells B1:D2 in 'worksheet one'. Go to 'worksheet 2' and right click on cell F2 and click 'paste values' and select 'Transpose'.
After you copy the data, use Paste Special (keystroke Alt-E-S)
Select the transpose options, and it will swap Rows/Columns.
Going for Guru! Click the Star to the bottom left of this post if I helped!
in F2
=OFFSET(Sheet1!$B$1,INT((ROW()-2)/3),MOD(ROW()-2,3))
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks everyone for your help. I tried Special-K's formula and it worked! Thanks again for your help. I kept googling with no success on how to do it....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks