Hi,
I am new to this forum and I looking an alternative way to pull values from another table. I tried Table. SelectRows but it takes long time to generate the total when there is lots of data even after using Table.Buffered
Presumably you have a column or columns which determine whether you want the row or not.
You could try either filtering on that/those column(s), or Group By, or a Merge. [note re:
Group By will allow you to aggregate at the same time as 'selecting' the rows, whereas Merging won't]
More details required, ideally a workbook with a realistic representation of what you're trying to do.