Macros to populate dynamic listing into defined layout

[Shermaine2010]

Hi,

Macros to populate the dynamic listing and add in sum & average then into the defined layout is completed.
There is a new requirement that the defined layout split the average into mid-year and year-end which side by side. The Mid Year listing to remove by remaining the average data.

Refer to the file attached,

• No color sheet - OKAY macros for existing raw data and the macros result

• Green color sheet - new column (A) Review (Mid Year and Year End) inside the new raw file. NEW_RESULT & NEW_RESULT_2 is the ideal result

Please help

Thanks

[Ochimus]

Shermaine,

Can you clarify what the values in Col B represent, as I can't see them in the original Raw Data?
What is the significance of "EE" in B3 which the Macro is adding?
And are you adding the Review period in Col A manually?

Ochimus

[sintek]

If I refer back to your initial thread a couple of months ago, before this new changes, the figures in the result sheets do not seem right...
I suggest you explain in step by step detail where the figures come from and how these results are calculated...