Hello,

This is the file I need to sort:

http://www.fileswap.com/dl/nsdXSyLrk...52012.rar.html

So here's the explanation: For each day I receive several inputs of
listings in time , excel docs, that I have to organize them in one
unique result, applying some simple calculations:

My goal is to create one file per day, based on those daily inputs. I
copied these different excel docs across and organized them(all stati
values, no averages) and pasted in tab "draft" , "pressure" , "raw"
... they are all referenced with different time stamps but on the same
day:

draft tab draft is taken at a given random time, i.e. 06.13am, (the
only column to consider in the draft tab is "L") so, at 6.13 the draft
is -0.295

pressure tab some intervals: for example from 06:21 to 06:52 the
pressure is 1019.25 (consider just mean pressure)

raw tab for a whole given day I get a time and a value of tide ( a height)

I created then a "result" tab, (first tab) , where I joined all these inputs:
time and tide are the ones from the raw tab, then the pressure changes
according to the interval in "pressure tab" and draft changes
according to the interval in "draft tab" , I wasn't able to create a
VLOOKUP routine so what I did was to copy across manually the
intervals of "pressure" and "draft" into the "result" tab, ordering
them according to the timestamp in column A.
So for example, in pressure tab, the value of pressure from 06:21 to
06:52 , is 1019.25 ( to be considered only the mean pressure) so I've
manually located this interval in "resluts" tab (columnA) and pasted
the value 1019.25 all along the interval 06:21 to 06:52 , which is the
same for the whole interval.

... I did the same for draft.

The result is an "adjusted tide" based on some simple formulas, but
that's irrelevant.

As you can imagine, the copy and pasting manually from tabs to result
is incredibly time consuming....

Do you think that a VLOOKUP could help? or else any input is welcome.

Thanks all again in advance!