Hi All,
Im in need of a report generation.
The data to be present on this report are stored in a folder say : "C:\Test"
Over here there are about 100 workbooks.
The requirements are as below:
1. The macro should browse these 100 workbooks.
2. Go to Sheet 1 of each workbook - Sheet Name : "Progress Report"
3. Collect the details required.
4. Copy and paste the details collected on a report format.
Conditions:
1. The project name, project manager and project number will always appear on the columns mentioned in the attachment.
2. The value financials indicated in sheet 1 of the attachment may be present at row number 17 sometimes, row number 18 or even row number 23.
3. Macro should search for the string Financials highlighted in bold and copy the subsequent two values adjacent to it.
The attachment on sheet gives the data to be copied
Sheet 2 gives the view on which the report should look.
Please refer the attachment.
Bookmarks