Hi, I am using StudioX to copy a cell value from excel reports into a main excel workbook. However, in each report, the specific target may not be in the same cell position. The value I want also varies with each report, but there is a fixed header that is always above the value.
For instance, one report may have the cell positioned at H63 wth the header above it at H62, while another report may have the cell positioned at H58 with the header above it at H57.
Is there a way for StudioX to find and read the cell value by anchoring the fixed header?