PDA

View Full Version : Solved: Autofill Series with a minimum and maximum



mhblake
06-10-2013, 01:43 PM
I can't seem to find the answer to this anywhere...

I'm working on building a tool that requires a sequential list of numbers with a given (though variable) minimum and maximum value. Incidentally, the space between the numbers can be variable as well as it has to do with salary levels.

Is there a way I can do a macro to automatically fill the list sequentially (i.e. $150, $151, $152) given a minimum and a maximum in unique cells?

Or is there an easier way to do this that's not using Macros? Any help would be greatly appreciated!!

Thanks!!

p45cal
06-10-2013, 04:12 PM
see attached.

mhblake
06-10-2013, 04:19 PM
This is perfect-thanks so much!!