fareedexcel
Member
Hi Excel Pros,
I have an excel form with employee data in Workbook.
Also in a folder, I have multiple workbook with multiple excel forms. I need help to get the data from those workbooks and copy as VALUES in an new OUTPUT sheet.
The code should go to a particular folder where I have saved all the workbooks, then open each workbook copy the data to the OUTPUT SHEET. The concern is each workbook may have multiple worksheets (Multiple Forms)
Please help in getting the data.
I have an excel form with employee data in Workbook.
Also in a folder, I have multiple workbook with multiple excel forms. I need help to get the data from those workbooks and copy as VALUES in an new OUTPUT sheet.
The code should go to a particular folder where I have saved all the workbooks, then open each workbook copy the data to the OUTPUT SHEET. The concern is each workbook may have multiple worksheets (Multiple Forms)
Please help in getting the data.