1
vote
1answer
2k views

Dynamic Sheet Reference in Excel Formulas

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 ...
0
votes
1answer
107 views

How to get the data from one cell to alter the function of other cells

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 ...
0
votes
1answer
3k views

Excel 2007: Automatically insert row if previous row is filled in

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 ...