Now that I have the formula or Vba code, apparently there is a difference-
There certainly is,
- a formula goes in a cell on your actual sheet and returns a value to that cell
- vba goes in a vba module, is triggered by some event, and may perform many different tasks.
I need to be able to install it into the spread sheet somehow.
Not exactly sure what you mean by that, but maybe I have answered that (at least partially) below.
All I can do now is run the program from the macro editor.
There are many ways you can get the code to run, including ...
- From the Developer ribbon (If you can't see the Developer ribbon then Office Icon|Excel Options...|Popular|Top options ...|Show Developer tab in the ribbon|OK) click Macros
- From the View ribbon choose Macros|View Macros
- You could add your macro to the Quick Access toolbar
- You could add a Command Button on your sheet to click to run the macro
- You could have the macro automatically run when a particular cell is changed (or even just selected)
- There are many more options as well.