Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range
Hello,
I am a newbie to VBA and have been tasked with a problem:
I have 5 values on a separate sheet that are calculated based on multiplying static values by a varying portion, then that number is either rounded up or down based on a Y/N column next to the portion value. Each portion can be different for each "customer" and there can be a varying number of "customers" for each case.
Right now, those 5 values are automatically calculated using the first row of that "customers" table. I would like copy the table with those 5 values to a new worksheet, update the table with the portion and Y/N values in the next row of the "customers" table, copy that table with the updated values to a new worksheet, and so on...
I've scoured the internet for resources that may help but I've been unable to find anything that may be of significant help.
|