Hello All, Can someone write a macro for the following 1) If I have 10 files open. 2) copy from cell A3 to last but one row and copy till 'column U' 3)copy the whole data from 10 files, 4) paste in the new excel workbook one after the other
5) next for 'Column V' it should take the file name 6) afterthat i want a 'MessageBox' asking for 'Submitter Name' 7) after i give the 'Submitter name' it should be pasted in 'Column W' *Summary:* In the new file i shoud have from Column A to U --- body of the file from the whole 10 files Column V ---- File name column W- submitter name This would be a great help for me thanks in advance. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
