create a VBA loop to sum up results
Budget: £10 – £20 GBP
Hi all, I need a very simple VBA code that, in the spreadsheet attached, takes the resulting values in the sheets "Asset 1" to "Asset 10" from column K included onwards (see range below) and sums them up and writes them in sheet "summary" that is identical to the "asset 1" to "asset 10" sheets.
I need a VBA because summing all these assets up by using a formula would make the file unmanageable.
Please note that due to confidentiality I had to remove all names of rows and columns and as a result the cells appear to have a #ref error. You should not worry about that. You can use dummy numbers to sum them all up. You need to make sure that all values (although now #ref) in the range K13:SX700 are summed and reported in "summary" sheet.
I need a VBA because summing all these assets up by using a formula would make the file unmanageable.
Please note that due to confidentiality I had to remove all names of rows and columns and as a result the cells appear to have a #ref error. You should not worry about that. You can use dummy numbers to sum them all up. You need to make sure that all values (although now #ref) in the range K13:SX700 are summed and reported in "summary" sheet.