# Question Inserting Rows based on cell differences and interpolating in between

1. ## Question Inserting Rows based on cell differences and interpolating in between

Hello -

I have a complicated issue. I have a file with 5 columns (A, B, C, D, E).
A is fixed string value.
B is a number increasing irregularly.
C, D, E, are given values.

What I need to do is have column B regular (i.e. every 1). So I have to insert rows between B i.e.(B2-B1) will determine how many rows between B1 & B2 and then (B3-B2) will determine how many rows between B2 & B3 and so on.
After inserting the rows, I have to linear interpolate columns C, D & E in the newly created empty rows. In all cases I want to keep the original values and interpolate between them.

The other issue is that column B has decimal/fraction, but I think I can round this to the nearest integer to make it easier for interpolation.

I tried this one but I think I have a problem with the insert loop!

``Please Login or Register  to view this content.``
Example Input: http://i65.tinypic.com/v30kz6.jpg
Desired output: http://i66.tinypic.com/2hrod4n.jpg

2. ## Re: Question Inserting Rows based on cell differences and interpolating in between

Other posts I have in other forums - I apologize for not posting these earlier:
http://www.mrexcel.com/forum/excel-q...g-between.html
http://www.ozgrid.com/forum/showthre...001#post776001
http://www.vbaexpress.com/forum/show...tween&p=348053

3. ## Re: Question Inserting Rows based on cell differences and interpolating in between

I had help here: http://www.vbaexpress.com/forum/show...ing-in-between and it works perfectly now.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1