Good day! I would like to make a summary of my table using excel vba.
From attached file, i have a number of rows which specify the name/number of rooms in col B and at col C mentioned number of occupied rooms.
If the value in col C, for example show as "Occupied 2" it will take the first 2 rows and make the summary table which is shown on col E to J. if it is "Occupied 8" it will occupy the 8 rows.. and so on.
if the next rows (after occupying the number of rows mentions) is vacant, it will count the number of vacant until it reach the row with values again.
This will have a loop until the last rows in col B and create the summary table.
Thanks in advance.