Sorting help.

[kel1306]

I have a workbook, with multiple worksheets. Sheet 1 is my master sheet. The other sheets have links to the table in Sheet 1. The reason is so that I can change data in Sheet 1, and the calcualtions in the other sheets will reflect those changes.

I am wanting to sort the data in Sheet 1 without loosing my links in the other sheets. I am able to cut and insert rows in Sheet 1 and the links are maintained to the correct cells, but when I try to sort the rows, the data link is not maintained. Im sure it is a simple setting, but I don't know how or where to find it. Thanks.

[6StringJazzer]

Welcome to the Forum kel1306!

It is not a setting, and it is not simple. The solution depends somewhat on how your formulas refer to the cells on Sheet 1. To give you a solution that we know will work for your file, it would help if you attach the file. See yellow banner at the top of the page. Even if you have to delete private data, that's OK, I would primarily need to see the formulas on the other sheets. Also describe what kind of sorting you are doing.

[kel1306]

Thanks for the reply,

If you could explain a bit of the process it might be best. The this workbook is related to some state government data, and I'd have to do alot of deleting and other work to be able to share it.

The simple explaination is this. I have a table in Sheet 1 that is my "master list". That table is then pasted as a link into 4 additional tables. In the 4 additional tables, i add more data in new columns to do some further calculations
that are in more columns. There are no formulas in the links, only links to cells with numerical data. The idea is that I can manually change data in Sheet 1, and the other sheets will return new data.

I want to do a simple sort in Sheet 1 by the first column, but my linked data is changing, (I guess I already explained that)

[6StringJazzer]

I am wanting to sort the data in Sheet 1 without loosing my links in the other sheets.

Do you mean

1. You want to sort and have the sorted order reflected in the other sheets
2. You want to sort but still have the other sheets reference data in the original order

I have a table in Sheet 1 that is my "master list". That table is then pasted as a link into 4 additional tables.

How do you paste a single table as a link to four different tables?

So the links back to Sheet1 are by your "paste with link", not by using formulas to reference Sheet1?

[kel1306]

So, #2 best describes what I’m doing.

Ok, yes the pasted table cells link back to sheet 1. So as I change numbers in my Master sheet, those numbers then will change in my tables on all four following sheets. I have not written formulas to reference sheet 1.

[6StringJazzer]

When you refer to "tables", do you mean just a range of data, or do you mean structured tables?

[kel1306]

Um, well not sure what you mean. I’d call it a table, but I suppose the part of the table that I’m trying to sort is a range of cells. Would be A6:R360

[kel1306]

Based on the definition of structured tables, I’d say the area I am sorting is a range I’d data

[JeteMc]

We may be in a better position to help if we could see a sample.
Information on attaching a workbook to your next post is given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
Let us know if you have any questions.

[6StringJazzer]

Um, well not sure what you mean. I’d call it a table, but I suppose the part of the table that I’m trying to sort is a range of cells. Would be A6:R360

For more information see the link I provided above.

structure table.jpg

[kel1306]

Yes it is just a range of cells.

That being said, I just took the time to manually cut and past the information into the order that I need. I wouldn't mind knowing how to do it correctly, but I was wasting too much time not getting it done.