linking info across worksheets within single workbook

[Guest]

Hello,

I am not very sussed on the higher functionings of Excel so would appreciate
help with the following:

I have a lot of info to input into very wide table (about 50 columns which
fall under about 5 subheadings). This data will need to be sorted according
to different criterion. Although complex, this project has a lifespan of only
a month.

I would like to be able to spread the different section across different
worksheets within the same workbook, so it can easily be viewed in separate
coherent sections. - Data across one row across all columns of all
spreadsheets would relate to one single item. I fear this relationship may
get jumbled if I sort data.

- is there any way of linking data across worksheets so that when sort
command is given info across all worksheets is sorted together as a whole?

much appreciated
Lynda

 

[Frank stone]

hi,
don't think you can do that.
the sort function seems limited to sorting the range that
you select. only.
you can do it though but only 1 group at a time.
to prevent jumbling of the data i would index all the data
on each sheet with a index column and numbering the
records 1 through however many records you have. if mixup
occurs, you can sort by the index to put thing back to
original.
make a second index column or sort column for all the
sheets.. when you sort data on sheet 1. copy the first
index column to the second index column on sheet 2. sort
by the second index column and the data on sheet 2 will be
in the same order as on sheet 1, records matching records.
yes, a bit manual but if it's only going to last a month
maybe you can hassel through it. if not then maybe the
data should be all on 1 sheet.
sorry i couldn't be more help.
Regards
Frank