Hi All,
I am currently working on some data which needs to be popilated into our yearly planner database.
As shown on the attached, the data tab holds the reference numbers which are needed and the planner tab is were we need to automate this sheet to lookup and return set data from this tab onto the planner.
As you can see on planner tab, each month has its own column, so for each month from Jan onwards we are required to carry out planned works and I want to be able to program the attached to search the data tab and populate each monthly column based on the search criteria (property name and repair) and to ensure the work listed as 1/1/2020 is added in the column for January.
Hope someone can urgently help.
Bookmarks