Macro to add formula to columns & then sort data

Hi all,

I am currently using a macro to merge the data from all sheets to into one, and would like to make it also create a new row with headers and add formulas to columns that will split the full name in the first column into first, middle, last after it copies all of the data.
For example, I run the macro, it copies data from all sheets to "mergedsheet", then inserts a row at the top of mergedsheet, with headers FullName,FirstName,MiddleName,LastName...etc... and finally, splits all names in FullName into FirstName, MiddleName, LastName.

The current formula I am using is below. Thanks!

Please Login or Register  to view this content.