Sedang Disiapkan

Macro loop Data list

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.

Kemahiran: Excel, Visual Basic

Lihat lebih lanjut: macro sum multiple column, macro loop list, week end update, i parcel, excel macro how to, loop macro excel, excel macro loop column, macro search data loop, macro list data, project macro loop, macro loop colun, macro loop column add data list, loop macro multiple rows, macro loop find sum, datalist macro, inputting multiple data vba macro, loop sum macro, loop til excel makro, excel vba create loop list, macro loop list data, code update list everyweek, list loop vba, loop macro count items spreadsheet, macro loop multiple columns read data, multiple cells macro

Tentang Majikan:
( 2 ulasan ) tempe, United States

ID Projek: #384376

4 pekerja bebas membida secara purata $121 untuk pekerjaan ini

MAnkita

Hello,Thanks for [url removed, login to view] refer your [url removed, login to view] you.

$125 USD dalam sehari
(75 Ulasan)
6.1
CodeGuru123

Hi Please check ur pm.

$250 USD dalam 5 hari
(12 Ulasan)
4.9
KellogITSolution

Hello Please see your PMB for dtails. Thanks

$110 USD dalam 3 hari
(15 Ulasan)
4.4
Sudharani17

hi please check PMB

$150 USD dalam 3 hari
(0 Ulasan)
0.0
unieyes48

Respected sir, please check my pm

$100 USD dalam 2 hari
(0 Ulasan)
0.0