I have several rows of data with (loan) acct #s. Each account has a column that has multiple parcels associated with them and they are numbered in a column.
The loans vary as to how many parcels each have. I get a new list every week so I need to input calculations after the numbered parcels end and before a new list parcels begins and so on. I need a loop that will auto sum certain columns within the range of preceding list of parcels. Finally after the rows end, I need a calculation of the rows (in the column) above that only have calculation.
I also need to update fields in a column and need the cells to turn red after they have been updated.
I know vba somewhat and have included some code in the attached files. I also input the calculations in some rows as well. I have attached the initial spreadsheet that will always vary when it comes to the amount of loans and correlating parcel numbers.
It’s complicated to explain so I attached the spreadsheet.