Sample Workbooks
Randon Sample Workbooks
Degrees Formula
Degrees Formula

copy Files to a different folder
copy Files to a different folder
Conditional Formatting
Conditional Formatting
Copy a range and Paste into outlook
Copy a range and Paste into outlook
The Code
Hyperlink Macro
Hyperlink Macro
Find Data in a column and copy\paste to a new location
Find Data in a column and copy\paste to a new location
Find Row and column
Find Row and column
Enter a value in the row and column
Change State Name into state abbreviation
Change State Name into state abbreviation
Here's an example, it uses
1. Vlookup,
2. A macro to change the State name to Abbreviation by clicking a button
3. VBA with a worksheet change that will automatically change the State name to Abbreviation when you change A20.
Copy Multiple ranges into an outlook email
Copy Multiple ranges into an outlook email
The code will loop through column A, if it finds a check mark, it will copy the range next to it into the outlook email.