I would like to select a range based on cell value.
For example:
The cells C1:L1 contain the descriptions.
In cells C2:C13 I have alle the months (01-01-04, 01-02-04, etc.)
The cells D2:L13 contain supplies.
Cells D14:L14 contain the totals of the column.
Now I want to select C1:C13 and the rest of the columns until the value in row 14 reaches 0. E.G. F14 = 0, so I want to select C1:E13. Is this even possible???
For example:
The cells C1:L1 contain the descriptions.
In cells C2:C13 I have alle the months (01-01-04, 01-02-04, etc.)
The cells D2:L13 contain supplies.
Cells D14:L14 contain the totals of the column.
Now I want to select C1:C13 and the rest of the columns until the value in row 14 reaches 0. E.G. F14 = 0, so I want to select C1:E13. Is this even possible???