Loop, calculate and copy results

[JakobP]

Hi everyone

I am not very familiar with Visual Basic and need some help.

I have a table that calculate costs and depreciations based on pre-selected inputs. The inputs are categorized according to the asset in question, numbered from 1-1.000 (representing 1.000 assets in total): Everytime a certain number between 1 and 1.000 is entered in a specific cell (in my case, B17), the rest of the calculation will retrieve the relevant cost inputs from an underlying spreadsheet, e.g. unit costs. This part of the calculations are working fine.

However, I would be pleased if anyone could help me with a simple VBA-formula that:
1) Loops cell B17 from 1 to 1.000
2) Exports the result rows to a sheet within the workbook without overwriting anything.

Thank u.

 

[OaklandJim]

Without knowing more this seems doable. Unfortunately, your description of what is needed is just too vague and not detailed enough for many list users to help you.

Plus, ideally you provide a link to your workbook. Otherwise, someone willing to assist might need to recreate it to develop and test the necessary code. Put the file on Box, Dropbox, 1Drive, Google Drive or Sharepoint. Provide a link to the workbook using the link icon at the top of the message box.

Also, consider using Mr Excel's excellent add-in called XL2BB which enables you to post a portion of a worksheet. With that add-in you can show relevant data in a usable form. That way someone willing to help you does not have to create fake data or guess what your data looks like. See XL2BB - Excel Range to BBCode for details.