You reference cells in a similar style to Excel cell references. Excel references have been extended to allow you to reference entire rows or columns. Smart row references are available to refer to ...
UPDATE: This project has been transferred to VBA code within the Excel datasheet. This repository remains for legacy reasons and will not be further updated, but the project will continue! Thank you ...