VBA not updating properly

[atomichybrid]

Hi all,

I have a problem with this code I had started working on (see code below). The code keeps generating numbers next to each other and cant seem to find the logic behind it. Any comments on the code would be greatly appreciated.

Cheers

Please Login or Register  to view this content.

EDIT: I suspect the triple nesting is the problem. If there is a practical approach please let me know.

[Leith Ross]

Hello atomichybrid,

Please provide some before and after examples of how the data should look on the spreadsheet.

[atomichybrid]

Yes it would seem that I can't get support if I didnt put up the file. Here it is, I've change some around to make the calculation faster. I now have a different problem which is the rates not popping up correctly as I put down the rules.

headache.xlsm

Cheers.

[Leith Ross]

Hello atomichybrid,


Is this an estimate calculator for duct work?

If it is, are you calculating just raw material costs per linear meter?

[atomichybrid]

Yes Ive figured the per lineal meter part but I want singular items like the 90 bends, dont know how to work that out.

Also is quadruple looping a good idea? its getting really messy.

[Leith Ross]

Hello atomichybrid,

Since air volume and friction directly affect the size of the duct needed, shouldn't you also include these in your cost estimate?

[atomichybrid]

Leith,

This workbook I'm trying to develop is when the calculations of the static pressure and duct sizing is already accounted for. I want to estimate the cost of the ducts so I have a fair idea of the cost for particular projects. I hope this clarifies things.

Cheers

EDIT: I've worked out how to put the rates now I have a new problem I want to put these rates to a separate sheet, and it seems to go in a continuous loop when add a fourth "For each" loop into my existing one. I open to alternative solutions on how to transfer the rates to a different sheet. Thanks