Correction in code to re arrange data

HI All

the result of the of the macro is in tab Capitalisation

Below macro filters the right data in Site_assumptions and arranges into Capitalisation tab

Example

AT2 Krottenbach Jul-71 New sites Nov-17


However i need to add in column F "Engineers" and "Site finders" per site and i don't know how to write that


Hence it has to look like :

AT2 Krottenbach Jul-71 New sites Nov-17 Engineers
AT2 Krottenbach Jul-71 New sites Nov-17 Site finders



manyb thanks!

Please Login or Register  to view this content.

Hi your code only works for 1 site

it doesn't include the "Engineers" and "site finders" in code AT3

Code Name Opening Status Action date CAPITALISING COSTS
AT2 Krottenbach Jul-71 New sites Nov-17 Engineers
AT2 Krottenbach Jul-71 New sites Nov-17 Site Builders
AT3 Linz Lastenstrasse Feb-72 Renovation Apr-18


thanks in advance

AC

THIS CODE WORKS BETTER

Please Login or Register  to view this content.

thanks anyway