3 problems-Autosort, Copying, and hard to explain

Firstly I am by no means any good on excel, I am still learning lots myelf - but can't help but feel these suggestions make sense.

1) Not sure what your sorting problme is, if you add some samples with completed rows of data might be able to help. Can't test the sorting of empty cells.

It might be something silly, the sort function is tempermental and needs to have other filled cells next to it for it to sort all of the data. If all of the cells in a row under the column headers are filled in it should sort, but you never know. Computers will always have a mind of there own.

2) To copy a sheet, right click on tab for the sheet > select move or copy > check copy box > select new book from drop down menu

This will create an exact copy of the sheet in a new book, which you can save wherever and as whatever you wish.

3) From what i understand you have 15 people that wish to use this spreadsheet.

Will each of them be feeding into 1 sheet or are you planning on have one book with 15 tabs, one for each of the 15 users?

If this is the case make sure that you have access to the drives that theseversions will be saved under. If you don't have access to the files there is no real easy way of doing this.

If above okay try this:
Create a book that has 15 tabs, each looking exactly the same. You can do this the same way as above, create a copy in a new book and then create 15 copies from that book into the same book. This way all the sheets will be formatted the same way.

The in the first tab, cell A3 (first empty cell) type: = (then click on the cell A3 for the first sheet that you wish to link)

Once this has been done the formula will look something like this:

=(['Spreadsheet1'!]$A$3)

delete the $'s so that it looks like "A3"

Then drag this right to copy to all cells to the right and repeat for cells beneath.

This should link all the cells that have this new formula to Spreadsheet1. Repeat for all 15 spreadsheets, each with a different tab in your 'Master' book.

I hope this works and makes sense, please post a response to let me know what happens and if it works.

Best of luck.

Ok, I have the first two figured out. As far as the 3rd goes, I have the "Master" sheet created with a tab for each sheet. I typed in the =, but then the sheet I'm trying to link to gets grayed out and I can no longer switch to it in order to click on the cell. How do I get around that?

Thanks by the way.

I have tried a few things and I can only get it to work when I open them both in the same program.

I think it might work if you open the master sheet as normal and then to open all of the other files I would open them one at a time, by using the open icon whilst still in the master sheet.

Try =['Spreadsheet1.xls]Sheet1'!B3 Or what ever it should be

Then if it works close spreadsheet 1 and repeat for 2-15

Like I said I am by no means an expert on excel, I hope it works this time.