Column G is my Service Duration.
Column H is my Next due service date.
Column I is my Last Service date.
Column J is the service description.
Column K is the Contractor in charge of the service.
Related Data is arranged in the same Row from G to K.
I need a VBA code that on the click of a form button, will search Sheet "Service Schedules" column H for dates that are before and within the next 30 days of today and copy this information Row G to K to a new created sheet giving the sheet the name 30days in the same row format and to include at the top Row1 the header in Row1 of the new sheet.