Forum Discussion
Macro to replace array formulas
A new question. I have another spreadsheet which is a conglomeration of data regarding truck trips. Unfortunately the design of the sheet is not conducive to getting data. I have been working on a new concept for this which would allow for sorting of different portions of the trips (basic trip data, fuel add data, issue data and fault code data), but these also span different tests. So at the top I created a section called 'Ongoing test summary). I want to be able to show the total truck data as well as data related to specific test plans (identified as RG##### where the pound symbols represent specific letters.)
The array formulas I use work perfectly, but the workbook could have anywhere from three to 30 different tabs (one for each truck) which then makes the entire workbook very slow and freezes up my system. Wondering if there is a macro or better formulas (and I don't know macros or VBA at all) that would resolve this dilemma.
Appreciate any help you can offer! (I attached the new concept spreadsheet)