[SOLVED] Need help creating VBA code for interpolation

**FatnessFirst** · 01-13-2016, 01:22 AM

Hi guys,

I'm trying to create an aircraft counter for airplanes that are on ground in the airport.

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 use VBA, I've done basic coding through Matlab and C++ but that's all.

**jindon** · 01-13-2016, 04:33 AM

Delete 1 st row then run the code.

Please Login or Register  to view this content.

Alter OutPut cell to suite.

**José Augusto** · 01-13-2016, 06:35 AM

Or try these

Please Login or Register  to view this content.

See the file Book1 (2).xlsm

**FatnessFirst** · 01-13-2016, 08:31 AM

I shall try this first thing tomorrow. Thank you so much guys. Working or not, im very grateful

**jindon** · 01-14-2016, 08:08 PM

FatnessFirst,

Thanks for the PM and rep.

[SOLVED] Need help creating VBA code for interpolation

LinkBack

Thread Tools

Rate This Thread

Display

[SOLVED] Need help creating VBA code for interpolation

Re: Need help creating VBA code for interpolation (kinda)

Re: Need help creating VBA code for interpolation (kinda)

Re: Need help creating VBA code for interpolation (kinda)

Re: [SOLVED] Need help creating VBA code for interpolation

Thread Information

Users Browsing this Thread

Similar Threads

Need help (urgent) - Code to reduce data and linearly interpolation back to original size

Hello! I'm 'new' (kinda)

linear interpolation function vba code

assigning pages tall/wide within existing code [solved, kinda]

Modifying a double interpolation function into interpolation/extrapolation function

Look ups? Kinda............

[SOLVED] Creating a count variable for interpolation

help with interpolation and limit of interpolation

Bookmarks

Bookmarks

Posting Permissions