Jonmo1
MrExcel MVP
- Joined
- Oct 12, 2006
- Messages
- 44,061
Ok, I'm new here this is my first post.
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
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