noodlestall
New Member
- Joined
- Apr 5, 2018
- Messages
- 2
I have a workbook with 2 worksheets.
One shows the report (Output) the other has the raw data (Raw Data).
I want the user to be able to easily amend the formulas (without having to understand them) if the structure of the raw data changes, e.g. new column added.
I have a header row on the output report (row 5) which contain the headers from the raw data for the columns I want to get data from.
Cell C1 contains 'Raw Data'!AN:AN which is the user ID column. This is so the user can just update this field if the user ID column changes. To use this I have had to use INDIRECT(C1) which is causing everything to slow down (getting the Calculating Processors 4 on the bottom right of the application).
Can anyone advise me of another way around the indirect part to speed this up (or any other way to speed it all up) There is potentially 100's or rows of data.
My formula is: =IFERROR(INDEX('Raw Data'!$A:$BJ,MATCH($B7,INDIRECT($C$1),0),MATCH(A$5,'Raw Data'!$1:$1,0)),"")
Regards
One shows the report (Output) the other has the raw data (Raw Data).
I want the user to be able to easily amend the formulas (without having to understand them) if the structure of the raw data changes, e.g. new column added.
I have a header row on the output report (row 5) which contain the headers from the raw data for the columns I want to get data from.
Cell C1 contains 'Raw Data'!AN:AN which is the user ID column. This is so the user can just update this field if the user ID column changes. To use this I have had to use INDIRECT(C1) which is causing everything to slow down (getting the Calculating Processors 4 on the bottom right of the application).
Can anyone advise me of another way around the indirect part to speed this up (or any other way to speed it all up) There is potentially 100's or rows of data.
My formula is: =IFERROR(INDEX('Raw Data'!$A:$BJ,MATCH($B7,INDIRECT($C$1),0),MATCH(A$5,'Raw Data'!$1:$1,0)),"")
Regards