|I still don't understand what you want the macro to do. Do you want it to put formulas in cells for you? Do you want it to accept input from users about customers and products? Something totally different than either of those? What do want to happen when the button is clicked?|
A macro is a series of instructions that can do things to a spreadsheet or just do things within VBA and put the result in a cell or perhaps pop up a message box with a value. the possibilities are countless. Nothing that you've told us so far makes it clear what you expect the macro to do for you.
I already posted an example of a countdown loop but without knowing how you are doing your current calculations we can't apply any kind of loop to your data.
Give us an example of the layout of your spreadsheet and the formulas that you are using and we'll see if we can point you in the right direction.
Before posting any example data, please click on the blue line at the bottom of this post and read the instructions on how to post data in this forum.
In addition, if you DAGS on how to write excel macros you'll get lots of tips that should get you started.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.