Sorting Multiple Worksheets

Originally Posted by ShellyB

I am sorry, this may be a stupid question but I have to ask it.

I am working on a spreadsheet that has a main "Client List" on one worksheet and then that information is populated the rest of the spreadsheets using cell = cell. However when I enter new information on the client worksheet, I can not sort the data without ruining the rest of the spreadsheets. Meaning when I sort it, the other data that pertains to the other worksheets doesn't sort with it...

Example...

One worksheet 1 Cell A1=10001, Cell A2=10002, etc... then on worksheet 2 I put Cell A1 (formula) =worksheet1,cellA1. However I then also need to type information in the rest of the cells on Worksheet 2.

But when I input more information on Worksheet 1 and sort it, the information doesn't sort on worksheet 2 and I don't know what I am doing wrong or what I should add...

Sorry, I know I rambled on about the same thing. Any help would be greatly appreciated!

On sheet2 you have placed data in column A, and then attached data in columns B, C, D etc to that.
You have then shuffled column A (by whatever means) so naturally the data will no longer correlate.

As the 10001, 10002 etc is a client/customer number you should simply type it into the second and subsequent sheet so that the data on those sheets relates to the attached number, not to the 'whatever' contents of a cell.

Your other choice is, before the sort, on Sheet2 (etc) copy column A and then Paste Special = Values back over itsself, this will retain the data correlation.
You can then add more =Sheet1!A~~ items up to the next sort.

Hope this helps.

---