Joining Worksheets

N

Naomi

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
 
O

Otto Moehrbach

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
[email protected]. Remove the "nop" from this address. HTH Otto
 
D

David McRitchie

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.
 
Top