This is my spreadsheet: I tried replacing the term Benco in the formula with the cell reference hoping I could drag the formula down and it would use the contents of the row containing the dealer ...
I have 10+ worksheets, with the same layouts, all containing data from different days jobs. I am trying to create a "SimpleSheet" that only pulls specific data from one days sheet in a nice layout. So ...
I want to make a worksheet which can be used as a printed receipt towards customers, this is the basic layout: Customer contact details (name, address, etc) these are fixed fields that may be empty ...