I have an excel sheet, with a table on the left, and some other information (not a table) on the right.
The table on the left uses the column A through column E, and this won’t change.
But the number of rows on the table varies every month, and I need to retrieve this table data only, using Read Range.
how could I do this? I cannot really specify the range, because I dont know how many rows will be there in the table. All I know is the column uses A through E.
But if I just read the whole page, the range can be wrong because we also don’t know how many rows some other information on the right side of the sheet are using.