Link to home
Create AccountLog in
Avatar of s a
s a

asked on

Sorting tables, filters, and pivot tables in Excel

Ver: Excel 2007

Hey all, I have attached a file which I needed help sorting (this is an example of a sheet with the actual data)

There are 3 sheets, the original with sub-sections, second sheet is filters without the sub-sections, third is pivot tables off of the second sheet

The issue is...say I change a priority# of a server in sheet 'Main', I need it to change the priority# in the reference point for the same reference in the other two sheets too

How would I be able to do that?

Thanks
test.xlsx
ASKER CERTIFIED SOLUTION
Avatar of p912s
p912s
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of s a
s a

ASKER

Ok, using vlookup....do I have to do that for EACH cell and its reference cell?
Avatar of s a

ASKER

Also, I see if I make a change in the main sheet, it changes the ref. point in the filters sheet, but not the other way around....it should do that as well, everything should be referenced in all sheets

Thanks for your help
>>using vlookup
Goes whevever you want to display data based on the value of another cell. You'll notice that I made the font blue on cells where there is a lookup. I generally do that so at a glance you know if the cell is calculated or something you enter manually.

>> ref. point in the filters sheet, but not the other way around
You want to type on the main sheet and have it update the other sheets AND type on theother sheets and have it update the main sheet.

Can't do that; something needs to me the master and in charge....
Avatar of s a

ASKER

Thanks...could you provide a little more intruction on how you did the blue font? And whether I do have to do a vlookup for EACH cell?
The blue font is just cell formatting. I leave the default of black font for all cells excepts where I have sums, lookups etc, those I change the font to blue.

>> And whether I do have to do a vlookup for EACH cell
I don't understand what you're asking here? In my example you can see that I did a lookup to pull data from the first sheet into the other sheets for all cells except the reference data - apple, orange etc...

Make sense?
Avatar of s a

ASKER

Sort of...I mean in the filters sheet, for each cell...do I have to go cell by cell and insert a vlookup? or is there a way I can just do a 'mass vlookup' to the main sheet?
No, you need to enter a formula in each cell.

If you look you'll see that I have an anchor for the column ($A2) and the range is anchored ($A$3:$E$15) in the formula so that you type the first one in the upper left and it can then be copied to the right and down.
Avatar of s a

ASKER

Thanks, I will try that...how would this work with the pivot table? Btw, as much as I love excel, not a very fun thing to do doing on new years eve!
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of s a

ASKER

Sorry, still working on this
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.