Hi All
the attached file contains 2 tabs
Sheet 1 & Sheet 2
the target is to create sheet 2 based on the information in Sheet 1
Sheet 2 A1 to P1 wil be already hardcoded so nothing to do in terms of code
Sheet 2 A2 to D2 and rows below needs to be in the same format (white) as the attached
Sheet 2 E2 to p2 and rows below needs to be in the same format (one row dark yellow the next light yellow) as the attached
the key thing sheet 2 has to populate only data that contains the words "Renovation", "Disposal", "New sites" in sheet 1
if we delete or add new rows in sheet 1, sheet 2 should update and reflect that change.
Thanks in advance
AC
Bookmarks