Make a Single report from Multiple reports.

**devpp** · 10-25-2013, 04:07 AM

Hi,
I have a different excel workbooks with name ProjectResourceReport-A,ProjectResourceReport-B,ProjectResourceReport-C,ProjectResourceReport-D likewise till ProjectResourceReport-Z.
I want to make a macro to make a consolidated report.
Each time I make a new excel workbook ProjectResourceReport-All and copy past all cells from each workbooks.
the columns in the workbooks are
i want this
1.JPG
from
these workbooks
2.JPG 3.JPG
Thanks.

**arlu1201** · 10-25-2013, 05:20 AM

I am sorry, we cant work with pictures.

Please attach a sample excel file or files with dummy data. Ensure that the format matches your original files.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**devpp** · 10-25-2013, 05:56 AM

Originally Posted by arlu1201

I am sorry, we cant work with pictures.

Please attach a sample excel file or files with dummy data. Ensure that the format matches your original files.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

hi,
I want the contents from ProjectResourceReport-A and ProjectResourceReport-B to be copied to ProjectResourceReport-All with a macro in the workbook "ProjectResourceReport-All"
I have sheets like