Hi all,
I have some reports to upload in a software. These reports are excel files saved in a folder. They have unique names and set format. Since these reports have to be in a different format to be uploaded I wanted to write a piece of code to get my work done in two stages:
Stage 1: Go to all the files in the folder and copy the first worksheet onto a new sheet.
Stage 2: Once all the sheets are in one master file, Copy paste certain columns from all reports in a new worksheet to prepare the format.
I can manage Stage 2, how do i approach Stage 1? Thanks for your help.
With regards,
Vishal Gupta
Bookmarks