$$Excel-Macros$$ S-Functions and User Growth Rates

2011-03-28 Thread busboy10
Hi All, I am trying to model user adoption based on a s-curve adoption rate for cities. So I have a simple s-function that shows town growth and I want to create a S-function for user growth based on the number of towns. The problem I am finding is that when the town jumps from let's say 1 to 2,

$$Excel-Macros$$ Hyperlink Funcitonality

2010-12-30 Thread busboy10
HI All, Trying to figure out how to get the reference cell that I am hyperlinking to within a sheet, to be aligned to the top left of the window. I have tried this with no luck Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Application.Goto reference:=ActiveCell, scroll:=Tru

Re: $$Excel-Macros$$ Non-Uniform Random Number Generator

2010-11-04 Thread busboy10
nd wrong > > Best Regards > > André Luiz D´Avila - Auditor > Moore Stephens Audit > 2010/10/27 busboy10 > > > > > > > > > Hi All, > > > Trying to do some modeling where I would like Excel to create a random > > number that is picked fr

$$Excel-Macros$$ Non-Uniform Random Number Generator

2010-10-27 Thread busboy10
Hi All, Trying to do some modeling where I would like Excel to create a random number that is picked from a known distribution. For example, I downloaded all S&P monthly data. Created a histogram and know the distribution. Now I would like Excel to randomly generate a number that follows the di

$$Excel-Macros$$ ActiveX Checkbox and AutoFilter

2009-06-03 Thread busboy10
Hi All, Is there anyway to have checkboxes in a cell and then be able to autofilter based on which cells have been checked? Ex. Creating a task list in column A and put checkboxes in column B, when tasks are completed they are checked off. Want to see what tasks are left so I would like to auto