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) a
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) a
