simple Excel question

[breadandbubbles]

basically ive got an excel speardsheet going. very basic stuff, basically a column of names and a few columns of numbers related to those names.

I have one sheet for every day of the week.

BASICALLY, i have it so that each cell in column A of each sheet corresponds to the same cell in column A in the first sheet, called Template.

so, Template has:

A

Jane Doe

John Smith

The Dude

and then sheet 4, for example looks like:

A__________________B____________C

Jane Doe____________8____________9

John Smith__________11___________33

The Dude___________12___________55

of course, sheet 4's column A just copies itself from Templates column A. if i SORT Templates column A differently, i, naturally, get this:

A

The Dude

John Smith

Jane Doe

BUT THEN, sheet 4 would look like this

A____________________B____________C

The Dude_____________8_____________9

John Smith____________11___________33

Jane Doe_____________12____________55

so now, Jane Doe, which before had '8' in column B has '12' in column B.

the rows dont stay together! of course.

so, obviously theres a better way to do this.

i cant find the answer ANYWHERE. any help?

Edited September 15, 2009 by breadandbubbles

[spacesurfer]

I don't think you can do that in Excel. Access is probably better suited for that.

Your numbers data in sheet 4 is not attached to the names in sheet 4, but your names in sheet 4 are attached to those in sheet 1. hence, you see that names are sorted but columns are not.

normally, when you sort, you also need to select all related to columns within the sheet. this doesn't work across sheets.

[breadandbubbles]

unfortunately, we dont have Access here. i know many people run into these sorts of problems using Excel for what Access was designed for.

so.......it cant be done? i didnt think so....

[jaclaz]

Make a "static" Data_Area on a sheet (that you WON'T sort)

And use VLOOKUP.

Or I am not getting what you are wishing to do?

Can you explain what is that you are willing to do/need (as opposed to how you are doing it and it is not working)?

jaclaz

[breadandbubbles]

actually, i cant. im going to look into those options though. i really appreciate this.

[jaclaz]

actually, i cant. im going to look into those options though. i really appreciate this.

See if this (unrelated) puts you up on a path leading to a solution:

http://www.msfn.org/board/excel-2007-compl...la-t137511.html

jaclaz