I have a workbook with a number of worksheets. Worksheet 1 contains the base
data. Worksheet 2 contains single rows of filtered data from 1, which is
updated from time to time with a simple macro. One cell of that filtered data
actually requires the data in the row below the the filtered data. I think
the offset function is the optimal means of extracting the contents of the
required cell by referencing a vlookup within the offset function, but having
no sucess - is it because the offset function doesn't work across different
worksheets? Any other ideas to address this issue will be welcome