Excel Macros and Scripts for use at work.
ren
f2e807759d
Updated the ColorRowsByJournal macro to dynamically process every worksheet in the workbook instead of targeting a single hard-coded sheet. The macro now loops through all worksheets, detects the first table on each (assuming one table per sheet), and applies conditional row coloring based on the 'Journal Number' column. |
||
|---|---|---|
| ColorRowsByJournal.vb | ||
| confab-lookups.vb | ||
| export-to-xls.vb | ||
| find-gauge-from-decimal-inch.vb | ||
| ImportToOTD | ||
| negative-tool.vb | ||
| open-linked-workbooks.vb | ||
| select-workbook.vb | ||