Make macro create unique files only once.If files exist amend them.

[RaghavendraPrabhu]

Hi DocAElstein

Thanks for the amending the code. Needs some minor changes though.

My apologies I did not mention that my supervisor inputs only columns A, B, C, D, F and G (via form).

Column E is blank indicating new work. So when he runs the macro the second time or more, only these new records with blank column E have to be appended if the unique workbook is available. Then update with the date the macro is run. Otherwise the amending of the code is perfect.

[DocAElstein]

Hi RaghavendraPrabhu,
I am sorry but I do not quite understand what you are saying in your last post.

If you want more help then can you try to explain again.

Perhaps you can show me with sample data what you want done.

Show or explain to me the typical Before situation, and then show or explain what the After should then look like when the code has run

Remember that any explanation will appear OK to you because you know the project well. You need to try to explain so that someone like me who has no idea about it can understand.

Possibly the explanation lies in the Files you have already supplied. I was / am not too clear on exactly what all those file are.
I assumed the master file had already been filled from the data files, and as I had no new data files I simply used them again so as to demonstrate how the modified code would append data

On the face of it I think it sounds fairly easy to do what you want, but it is not clear to me presently exactly what it is that you want
Alan