Hi all,
If possible, I need some help with the below:
Sheet 1 -
Main sheet with information for a number of groups. Contains numerous columns all with a filter to sort.
Sheet 2 -
Sub sheet with more detail than sheet one, broken down per group.
What I want is for the common data from Sheet 1 to automatically be updated on Sheet 2, when a change is made on Sheet 1.
At the moment I have a simple formula ='Sheet 1'!B5 and have also tried ='Sheet 1'!$B$5.
The problem I have is that when Sheet 1 is filtered into a different order, the data in Sheet 2 changes in line with the table.
I need Sheet 2 to follow the changes that are happening on Sheet 1 e.g. Sheet 1 B5 moves to Sheet 1 B20. I want Sheet 2 to now return the data in ='Sheet 1'!B20....
Is this possible?
Bookmarks