PDA

View Full Version : [SLEEPER:] Need help creating VBA code for interpolation (kinda)



FatnessFirst
01-12-2016, 10:41 PM
Hi guys,

I'm trying to create an aircraft counter for airplanes that are on ground in the airport. It's pretty self-explanatory once you see it.
But a simple explanation is, I need it to read 2 numbers then produce a vertical list of the numbers in between and the numbers itself

Example: 1 and 4

1
2
3
4

simple version is attached.

Just need to automate it from the before box to the after box. (attached)

Problem is that I've tried using formulas for 2 days now and I'm out of ideas.

The only thing I can think of is through VBA but I have no idea how to write VBA codes, I've done basic coding with Matlab and C++ but that's all.

VBA is my last hope. So any input/ideas/possible code is going to be GOLD for me.

p45cal
01-13-2016, 10:21 AM
cross posted at:
http://www.excelforum.com/excel-general/1121174-need-help-acquiring-data-in-between-automatically.html#post4287216
http://www.excelforum.com/excel-programming-vba-macros/1121441-need-help-creating-vba-code-for-interpolation-kinda.html

FatnessFirst
01-13-2016, 02:59 PM
Yeah noted. I had to post to 2 other forum/sub-forums because the main thread isn't getting proper answers and it was verring off-topic.

Sorry about that. I will delete the other two that doesn't have the solution.

Or let me know if i should keep all and just post the solution in each