I am linking cells from one workbook to another. The issue I face is the table I am pulling from is part of a dashboard type screen so rows are being added and subtracted above the data I am trying to pull. For instance currently the data I need is B50:I55, but if rows are added it may be B52:I60 or something like that.
What I am looking to do is find the table header in this case Bulk Inbounds and then return the next 10 rows beneath it so I always have the right data.
What I am looking to do is find the table header in this case Bulk Inbounds and then return the next 10 rows beneath it so I always have the right data.