#### Jonmo1

##### MrExcel MVP

- Joined
- Oct 12, 2006

- Messages
- 44,061

I'm using just an example of my problem, not the real data of coarse.

Sheet 1 collumn A contains data manually entered by a user.

Sheet 2 collumn A has formulas referenceing Sheet 1 Collumn A

Sheet 1 collumn C has formulas referencing the results of the formulas in Sheet 2 Collumn A.

There are of coarse other data in collumns B,D,E etc in Sheet 1.

When I sort all collumns in Sheet 1, the formulas in Collumn C change with it. Since the formulas in Sheet 2 Collumn A do NOT get changed when sorting Sheet 1, this makes the formulas in Sheet 1 Collumn C invalid.

How can I correct this?

Any help would be great