PDA

View Full Version : 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

SamT
01-13-2016, 03:39 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.
No. You are just impatient and rude.

Sorry about that. I will delete the other two that doesn't have the solution.
A You can't delete them
B. One of them has offered a solution: http://www.excelforum.com/excel-programming-vba-macros/1121441-need-help-creating-vba-code-for-interpolation-kinda.html


http://www.excelguru.ca/content.php?184

http://dictionary.reference.com/browse/cross-posting
http://thenextweb.com/2009/07/06/crosspost-crosspost/
https://www.whitman.edu/mathematics/eegtti/eeg_76.html

This thread is closed for rudeness by VBAXExpress Moderator. The User is not banned.