I have an excel 2003 spreadsheet that contains test results from multiple tests on multiple products. Each individual result is in a named cell. The cell name is in the format:
"result_x_Ty"
where x = Product No
y = Test No
Depending on other criteria, I then need to copy selected results into a report. This I do by filling an array with the necessary results:
result_ar(1,x) = [result_x_Ty]
Is there a way that I can achieve this with VBA ?
I have tried & googled with no success.
"result_x_Ty"
where x = Product No
y = Test No
Depending on other criteria, I then need to copy selected results into a report. This I do by filling an array with the necessary results:
result_ar(1,x) = [result_x_Ty]
Is there a way that I can achieve this with VBA ?
I have tried & googled with no success.