Transfer Data from Master Worksheet to Individual Worksheet

[BKelleher]

Please Help.

I receive a monthly download of individuals call-logs in one "Master File." For internal reasons, I need to separate every person's monthly call-log into individual worksheets. Unfortunately, the file is very large and copy/paste is very time consuming. I am operating on MS Excel 2007. Please let me know if there's a solution.

Thank you in advance for your help.

 

[cometorta]

VoG,

I have used the code below succesfully. Thank you very much!

However now I'm faced with the following issue. When automating your macro to be replicated across 50+ workbooks, I'm been asked to select the colum to extract by 50 times.

1. Is there a way to either have the macro 'remember' my first column and used the same column for the rest 49 files automatically?

2. Or is it possible to hard code the columm to G:G. The files need to be sorted by column G:G at the moment but who knows it may change the future so the more flexibility the better.

So I would prefer option 1.

Thanks in advance for your help.

Sincerely,

Francisco