Hi!

Can't really tell what it is you want.

Can you provide more detailed info? Be very specific.

Biff

-----Original Message-----
Ok what I need to do is to get the number from a certain
cell with all kinds
of data (Stocks) into a worksheet in wich I can modify my
investments.
Now the problem is that I get the data in the following
order:

DATE COMPANY HIGH LOW VOLUME
x x x x x

What I would like now is that as I will have to add more
data that the
'HIGH' and 'LOW' will be copied within a formula to
another worksheet in
which the Date can be found on the different rows and all
the companies are
filled in the columns now there are 24 different
companies I have to aquire
the stockindexes from.

Will this be possible? What I can do is to get all the
first stock indexes
correctly but as I try to autofill all the dates it
doesn't seem to work with
only just the VLOOKUP formula!

Any help will be greatly appreciated.

.