4 ms·
devs "hate" excel because you have to reference by col/row (C10 = tax rate, etc). But few devs know that you can name cells (and ranges and tables). Just to the
by viggity 4y ago
devs "hate" excel because you have to reference by col/row (C10 = tax rate, etc). But few devs know that you can name cells (and ranges and tables). Just to the left of the formula bar you'll see a textbox with the default name of the cell (C10). Just delete C10 and call it "tax_rate" and now you can reference "tax_rate" in all your formulas.
- major505 4y agoI did a lot of shit in excell using vb. Even spreadsheets connected to SAP using COM+ dlls. But still sucks having to do requests in VB.