How to Arrange mismatch Data

[niladri20052006]

Hi all,

is there any special way to copy and paste to arrange data.

For example I have 5 files and the data is in different format in all those 5 files. Is to possible to arrange the data in a particular format? or will I have to copy or paste the data one by one? I want only company Name, Contact names, Title, direct Phone, Main Phone email and websites. I do not need any other info.

Any formula or VBA?

 

[asma410]

You will have to write a macro to do this. You can record a macro to do this for one file manually & then change the code to do the same thing for other files. In the code try using the headers of the column (Name, Contact Names, etc.) as a reference to copy the data.
If this is just a one time thing, it is easier to do it manually.