process folder

  1. R

    Macro to copy selected cells from all the .xls files in a folder

    Hi All, I have a folder "D:\Documents and Settings\Rakesh", which has many .xls files. Each file has a sheet called 'Cover Note'. I want to copy cells B2, C2, D4 and F3 from 'Cover Note' of each file. These cells should be pasted in the current sheet, one row for each file. First cell of...

Some videos you may like

This Week's Hot Topics

Top