Excel... two sheets, same data, different views

[Spungo]

I don't know the answer but here are some keywords you can google to see if they're related to what you're trying to do:
VLOOKUP
HLOOKUP
pivot table
autofilter

I'm thinking of something like what cronos wrote

 

[AreaCode707]

Send me the spreadsheet and I'll do it for you.

When you're actively allowing TridenT to get away with pawning off his work on you, you MIGHT have a slight Excel addiction. You should get that looked at.

 

[TridenT]

It contains personal data so I can't send it to you. Even then, I rather learn how to do this myself! But I thank your offer.

 

[MrPickins]

Yeah for what I do, they aren't really needed. If I needed them, I'm confident I can figure them out in minutes. The current project I work on has 10's of thousands of lines of VBA code... it's really a project not meant for excel.

Keep in mind, pivot tables are not exclusive to excel.

I pivot data fairly often in T-SQL:

http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

 

[MrDudeMan]

When you're actively allowing TridenT to get away with pawning off his work on you, you MIGHT have a slight Excel addiction. You should get that looked at.

I was trying to create a reason to stop doing other work.

It contains personal data so I can't send it to you. Even then, I rather learn how to do this myself! But I thank your offer.

There's no easy answer just FYI. You can send a very small example with no personal data and then adapt the solution to the real spreadsheet.

 

[lykaon78]

Ohh... ohh... can I hijack this thread with my own Excel problem?

I do a ton of analysis with PivotTables and one of the main formats I use to display data is row percentages with the grand total being a number instead of percentage (pivot table default). How can I make this happen without any extra work?

Like this sample:

 

[rcpratt]

Is the data always in that format? I'd just use formulas.

 

[M0oG0oGaiPan]

til, i'm an excel noob.

 

[Carson Dyle]

Is it really necessary to have the three differently sorts on individual worksheets? You can easily create (record) macros for each of the different sorts and then tie the macros to key combinations, allowing you to switch between them almost instantly.

The bigger challenge may be learning to use dynamic ranges so that you can easily add data without having to redo the ranges in your macros. You should be able to Google that, though.

 

[TridenT]

I was trying to create a reason to stop doing other work.



There's no easy answer just FYI. You can send a very small example with no personal data and then adapt the solution to the real spreadsheet.

Here's an example of the data.
https://drive.google.com/file/d/0B-pptqd906AqOTJsZEo2LWpUaUE/view?usp=sharing