Hello everyone!
I converted a pdf file directory list of names, address, etc to a excel spreadsheet. The list contains about 3000 rows of information all in column A. Some records in the list have 5 fields(rows), some have 7 fields(rows), and so on and so on. They do all have an email address as the last row of their record that could be keyed on for a find/search. So I need a macro that finds the email address of each person in the list and inserts blank rows above it so that there are always an equal number of rows (7 fields/rows for instance) for each record. Then I want to run a macro that copies the entire column and paste's and transposes it into a second sheet so that all the columns line up and with no blank rows. It's amazing how much time a macro can save...! Thanks
I converted a pdf file directory list of names, address, etc to a excel spreadsheet. The list contains about 3000 rows of information all in column A. Some records in the list have 5 fields(rows), some have 7 fields(rows), and so on and so on. They do all have an email address as the last row of their record that could be keyed on for a find/search. So I need a macro that finds the email address of each person in the list and inserts blank rows above it so that there are always an equal number of rows (7 fields/rows for instance) for each record. Then I want to run a macro that copies the entire column and paste's and transposes it into a second sheet so that all the columns line up and with no blank rows. It's amazing how much time a macro can save...! Thanks