Summary report from multiple worksheets

[Chemistification]

Hi all,

I am trying to create a summary report (I have attached an example of how i would like it to look) that draws information in from multiple work worksheets.

All of the project highlights will be kept in the same folder. I have attached a copy of the project highlight report.

I would like to get it where i open the summary report, run the macro and it draws in information from each of the project highlights. (There will be different amounts of project highlights and with different names but they will all be in the same folder)

Can someone help me with if this is doable and any help with the code (i'm not great at vba and all help would be appreciated)

Many thanks,

C

[Chemistification]

Anyone seen anything similar?

[arlu1201]

When you run the macro a 2nd time, should the results from the 1st run be cleared out and fresh data input? Or should the fresh data be input at the end of the 1st run?

[Chemistification]

When the macro is run it should clear out the results from the first run and fresh data should be inported. Thanks for looking at it.

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

[Chemistification]

Hi Arlette,

Almost perfet thanks. Only problem is when it initialy copies information it puts it into the summary report in row 4. Then when i re-run the macro it doesnt clear this information out properly. Any ideas? Ive tried changing the cell references in the code but it didn't have the effect i was after

[Chemistification]

Hi Arlette. Ive tried it a couple of times and it works. Ignore the post above. The first time you run the macro it does something strange but then everytime after it works fine. Thanks for your help with this. Really appreciated

[arlu1201]

I have made some changes to the code in post 5. Try it now, it should be more reliable .