Hi,
I have spent days transposing information from multiple tabs into a single tab and a more user friendly format. Now, I am being asked to essentially re-do the entire exercise in order to transpose the data from 2 columns over... This would be extremely tedious, and I am wondering whether there is a way to program a macro for this or to use the offset functionality. Or anything else that would do the trick...
Example is attached.
Thanks for your help.
Not 100% sure I understand but:
L4 is simply to avoid repetitive calcs.
Please Login or Register to view this content.
If in reality the values being retrieved are always numeric then you can use SUMIF also:
Using the SUMIF method M5:S5 can be simply copied and pasted over C5:I5 to replicate results without need for modificationPlease Login or Register to view this content.
(L4 calc is not nec. in relation to SUMIF method)
In short the SUMIF approach is pretty flexible
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi coop and welcome to the forum.
If you structure your data as in the attached you might be able to do more with it. See the attached and two different pivot examples.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks