Excel Data Compilation / Macro / VBA
I have an excel file that contains personnel records for a variety of individuals. I have attached an example of the data portion of the file. There is personnel data in two separate chunks what I call major columns.
I need to create a separate worksheet (or file) of individuals from any email address in either major column that gives me the following as rows:
Name, title, district, email, address1, address2, address3, phone number
For any that exist in the source data.
For example, in the example source document provided the first row would output:
Roland Hobson, director, Baker Web Academy, firstname.lastname@example.org, 2090 Fourth St, ,Baker City 97814-3391, 503-867-3000
The full source file contains around 8000 rows with personnel data.