|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
please provide an example worksheet with the layout and include any code you have created
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy range of cells from excel to either bookmarks or to insert in table in word | hinchi1 | Excel Programming | 6 | 04-27-2020 01:55 PM |
Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range | FarStar | Excel | 17 | 07-26-2017 07:55 AM |
Copy dynamic range between workbooks | elieprolb | Excel Programming | 4 | 02-06-2017 12:40 AM |
Excel Formula: return a range of cells that match | tinfanide | Excel | 4 | 08-30-2014 07:03 AM |
Loop through folder of workbooks and copy range to other workbook | Snvlsfoal | Excel Programming | 3 | 07-29-2011 05:55 AM |