Copy and paste as Values in another Sheet

[fareedexcel]

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.

 

[Marc L]

Hi,​

​

must see :​

​

Consolidate data from different excel files (VBA)

Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.

chandoo.org

​

Merge data from all workbooks in a folder

​

 

[fareedexcel]

Hi Marc L,

I tried the code but the data is not populating in a single line, the code is just copying the data from the source sheet as it is. If you look in to my OUTPUT SHEET File, I need the data as values in a single row against multiple columns against each employee record.

 

[Marc L]

Activate the Macro Recorder and operate manually to copy values as desired :​

you will get a code base you can adapt using one of the previous links …​

​