Joining Worksheets
 

I have a roster that is in order by room numbers and the names are constantly changing on who is in the rooms. The problem is I have two other worksheets the information needs to be on. One needs to be in alphabetical order, the other in order by date of arrival/imput. Is there anyway to set it up to do all three with just one input. Thanks for your help.

Naomi

Joining Worksheets
 

Naomi
Is the information the same on all 3 sheets but just sorted differently?
You will need VBA for this. I would envision that you would have a button
on the roster (sorted by room number) sheet. You would change whatever you
wanted in this roster sheet and then click on the button. The macro that is
executed by clicking on that button would then update the other two sheets.
Is this what you had in mind?
If you wish, send me your file, or a sample of it, and I'll work up the
code you need. If you feel that the data is proprietary, just make up some
data. I need just the layout and sheet names. My email address is
. Remove the "nop" from this address. HTH Otto
"Naomi" wrote in message
...

I have a roster that is in order by room numbers and the names are
constantly changing on who is in the rooms. The problem is I have two
other worksheets the information needs to be on. One needs to be in
alphabetical order, the other in order by date of arrival/imput. Is
there anyway to set it up to do all three with just one input. Thanks
for your help.

Naomi




--
Naomi

Joining Worksheets
 

Hi Naomi,
You might also familiarize yourself with VLOOKUP Worksheet Function.
for merging data.
http://www.mvps.org/dmcritchie/excel/vlookup.htm

Certainly VBA would help with sorting (and maybe printing), which is actually
the part that Otto said he'd help you with.

If you are the only person that maintains all of the data and creates the repot
you might be able to put everything on one sheet and print variations of format
with a macro, or other means.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Otto Moehrbach" wrote in message ...
Naomi
Is the information the same on all 3 sheets but just sorted differently?
You will need VBA for this. I would envision that you would have a button
on the roster (sorted by room number) sheet. You would change whatever you
wanted in this roster sheet and then click on the button. The macro that is
executed by clicking on that button would then update the other two sheets.
Is this what you had in mind?
If you wish, send me your file, or a sample of it, and I'll work up the
code you need. If you feel that the data is proprietary, just make up some
data. I need just the layout and sheet names. My email address is
. Remove the "nop" from this address. HTH Otto
"Naomi" wrote in message
...

I have a roster that is in order by room numbers and the names are
constantly changing on who is in the rooms. The problem is I have two
other worksheets the information needs to be on. One needs to be in
alphabetical order, the other in order by date of arrival/imput. Is
there anyway to set it up to do all three with just one input. Thanks
for your help.

Naomi




--
Naomi