Difference between revisions of "Excel Macros"
Jump to navigation
Jump to search
imported>Bob |
imported>Bob |
||
Line 5: | Line 5: | ||
* [[Calculate Daily Averages / Sums from hourly data]] (written for excel) | * [[Calculate Daily Averages / Sums from hourly data]] (written for excel) | ||
* [[Freezing / Thawing Indices]] (written for excel) | * [[Freezing / Thawing Indices]] (written for excel) | ||
+ | * [[Cell Wrap]] -- Useful for long column headers in data spreadsheets. | ||
+ | * [[Data Split]] -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel |
Revision as of 10:20, 12 March 2008
Handy Code Snippets
This page contains links to several Excel Macros that Bob's made. Feel free to use or add additional ones.
- Save Macros in Excel-- a brief How-To
- Julian to regular date converter (written for excel)
- Calculate Daily Averages / Sums from hourly data (written for excel)
- Freezing / Thawing Indices (written for excel)
- Cell Wrap -- Useful for long column headers in data spreadsheets.
- Data Split -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel