Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-07-2021, 07:10 AM
bwosk bwosk is offline Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range Windows 10 Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range Office 2016
Novice
Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range
 
Join Date: Sep 2021
Posts: 3
bwosk is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 10-07-2021, 10:36 AM
Purfleet Purfleet is offline Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range Windows 10 Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

please provide an example worksheet with the layout and include any code you have created
Reply With Quote
Reply

Thread Tools
Display Modes


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
Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range 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 VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft