Hi Guys
Can anyone solve this: I need to transpose a column, say a1:a20 from sheets START to END on sheet 1. I would like to use the end:start method (eg. sum('start:end'!a1).
I have tried ={TRANSPOSE('START:END'!A1:A20)} but it give me a #REF! result. Is is possible to do this?
Any help would be appreciated. Thanks
Anyone help here?
Could you please try explaining with the help of a sample file?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlette. Ive attached a file. Normal 3D summing into Sheet 1 would be simple enough. However, when you want to transpose the columns to rows, with {TRANSPOSE('START:END'!A1:A20)}, it doesnt work?
Hope my problem is clear?
Why do you want to use the "Start:End" method? You can do it directly via code like this :Put the code in a standard module.
Please Login or Register to view this content.
Hi Arlette
Thanks, but your code kind of does the opposit to what I want. I need to add the figures in a1 to a20 from each sheet from START to END into for eg. a1 to t1 in Sheet 1. In other words it must add up and then transpose
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks