Hello,
I need some help in getting a VBA code to replace my array formulas as the spreadsheet is currently working very slowly (and having automatic workbook calculation off doesn't help as it takes up to a minute to calculate all formulas manually). Below is one of the array formulas that I am currently using (I currently have 7 columns of these with 172 rows and it is likely that there will be more rows that will need to be added).
Basically what I need it to do is to check a different sheet for an ID (which can be found in column A on both sheets), as well as find the word "Productivity" or "Quality" in column K (as there are multiple types of information under a single ID), and then copy either cells L, M and X if matched with Quality or L, M, Z and AA if matched with Productivity, and paste into the "Ready to use" sheet with this layout: From L to K for Quality or to H for Productivity, M to J for Quality or G for Productivity, X to L, Z to I, and AA to M.
Any help is greatly appreciated. Thank You
I need some help in getting a VBA code to replace my array formulas as the spreadsheet is currently working very slowly (and having automatic workbook calculation off doesn't help as it takes up to a minute to calculate all formulas manually). Below is one of the array formulas that I am currently using (I currently have 7 columns of these with 172 rows and it is likely that there will be more rows that will need to be added).
Code:
=IFERROR(INDEX('Report Data'!$M:$M,(MATCH('Ready to use'!A5&"PRODUCTIVITY",'Report Data'!$A:$A&'Report Data'!$K:$K,0))), "")
Basically what I need it to do is to check a different sheet for an ID (which can be found in column A on both sheets), as well as find the word "Productivity" or "Quality" in column K (as there are multiple types of information under a single ID), and then copy either cells L, M and X if matched with Quality or L, M, Z and AA if matched with Productivity, and paste into the "Ready to use" sheet with this layout: From L to K for Quality or to H for Productivity, M to J for Quality or G for Productivity, X to L, Z to I, and AA to M.
Any help is greatly appreciated. Thank You