okay so I have an array it has 3 columns and it is in a defined name range error_tbl
The location is on the sheet "errors" and the range is (A2:C26)
The first column has the values 1-25 in numerical order.
The second column performs an if statement and returns a value or "" and the third column checks the value of the 2nd column and if it is not "" then it performs a vlookup for a corresponding value, otherwise it also has ""
What I want to do is have a range on another sheet that runs a report when requested to get the values in "error_tbl" where the 2nd (or 3rd) column is not "" or blank and past them into a range in a new sheet.
Destination sheet is "reports" range for report is M1:P26.
I know there is a way to do this in some sort of formula using I think indexing, but I cannot recall how to do this, but also I only want the date to show when it is triggered by an "run_err_rpt" macro
I hope this information is enough to go by, but more than happy to supply any more information if required.
thanks very much in advance
The location is on the sheet "errors" and the range is (A2:C26)
The first column has the values 1-25 in numerical order.
The second column performs an if statement and returns a value or "" and the third column checks the value of the 2nd column and if it is not "" then it performs a vlookup for a corresponding value, otherwise it also has ""
What I want to do is have a range on another sheet that runs a report when requested to get the values in "error_tbl" where the 2nd (or 3rd) column is not "" or blank and past them into a range in a new sheet.
Destination sheet is "reports" range for report is M1:P26.
I know there is a way to do this in some sort of formula using I think indexing, but I cannot recall how to do this, but also I only want the date to show when it is triggered by an "run_err_rpt" macro
I hope this information is enough to go by, but more than happy to supply any more information if required.
thanks very much in advance